51.Can u copy the session in to a different folder or repository?

Yes. By using copy session wizard u can copy a session in a different folder or repository.But that.
target folder or repository should consists of mapping of that session.
52.What is tracing level and what are its types?
Informatica tracing levels can be configured at the transformation session levels and has 4 different
types of tracing levels. Terse – Log initialization information, error messages and notification of
rejected data in the session log file.
53.What is a command that used to run a batch?
Following are the steps to execute a batch file −
Step 1 − Open the command prompt (cmd.exe).
Step 2 − Go to the location where the .bat or .cmd file is stored.
Step 3 − Write the name of the file as shown in the following image and press the Enter button to
execute the batch file

54.What are the unsupported repository objects for a mapplet?

1)Stored procedure preload or postload is not possible.
2)Dont allow the not reusable sequence generator.
3)xml source qualifier
4)Normalizer
5)Nested mapplets.
55.If your workflow is running slow, what is your approach towards performance tuning?
System Use the following methods to identify performance bottlenecks: Run test sessions. You can
configure a test session to read from a flat file source or to write to a flat file target to identify source
and target bottlenecks. Study performance details and thread statistics.

56.What are the types of mapping wizards available in Informatica?

The Getting Started Wizard can create two types of mappings:
Pass through. Loads a static fact or dimension table by inserting all rows. ...
Slowly growing target. Loads a slowly growing fact or dimension table by inserting new rows.
57.After dragging the ports of three sources (Sql server, oracle, Informix) to a single source qualifier,
can we map these three ports directly to target?
No, For this you need to use 2 joiner transformations and the resulted columns can be connected to
the target.
58.Why we use stored procedure transformation?
The Stored Procedure Transformation in Informatica helps you to use or call Stored procedures inside
the Informatica Workflow. Using this transformation, you can operate Drop or Recreate Indexes,
Check for Space in a Database, performing Complex Calculations.
59.Which object is required by the debugger to create a valid debug session?
A valid mapping.
A valid mapping or a valid mapplet that contains a Source Qualifier.
A valid mapping or a valid transformation.
A valid mapping, or a valid transformation, or a valid mapplet that contains a Source Qualifier
60.Can we use an active transformation after update strategy transformation?
You can use aggregator/active trans after update strategy. The problem will be, once you perform the
update strategy, say you had flagged some rows to be deleted and you had performed aggregator
transformation for all rows, say you are using SUM function, then the deleted rows will be subtracted
from this aggregator transformation.
61.Explain how we set the update strategy transformation at the mapping level and at the session
level?
Double click on Session, click on Mapping tab | select SQ_EMP and set that to SOURCE connection.
Select Target and set that to TARGET connection.
Select Lookup transformation and set that to TARGET connection.
Click on Properties tab and set the Treat Source Rows as Data Driven .
click on Ok.

62.What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work
flow monitor?
The system hangs when 'Online' Server connect option. The Informatica is installed on a Personal
laptop.
When the repo is up and the PMSERVER is also up, workflow monitor always will be connected on-
line.
When PMserver is down and the repo is still up we will be prompted for an off-line connection with
which we can just monitor the workflows 
previously ran.

63.What is change data capture?

Change Data Capture is a software process that identifies and tracks changes to data in a database.
CDC provides real-time or near-real-time movement of data by moving and processing data
continuously as new database events occur.
64.Write a session parameter file which will change the source and targets for every session. i.e
different source and targets for each session run ?
You are supposed to define a parameter file. And then in the Parameter file, you can define two
parameters, one for source and one for target.

Give like this for example:

$Src_file = c:\program files\informatica\server\bin\abc_source.txt
$tgt_file = c:\targets\abc_targets.txt
Then go and define the parameter file:
[folder_name.WF:workflow_name.ST:s_session_name]
$Src_file =c:\program files\informatica\server\bin\abc_source.txt
$tgt_file = c:\targets\abc_targets.txt
If its a relational db, you can even give an overridden sql at the session level...as a parameter. Make
sure the sql is in a single line.
65.What are partition points?
Partition points mark the boundaries between threads in a pipeline. The Integration Service
redistributes rows of data at partition points.
66.What are the different threads in DTM process?
Mapping Thread: One Thread to Each Session. Fetches Session and Mapping Information. Pre and
Post Session Thread: One Thread each to Perform Pre and Post Session Operations. Reader
Thread: One Thread for Each Partition for Each Source Pipeline.
Dynamic Thermal Management (DMT)
The DTM process forms partition groups and distributes them to worker DTM processes running on
nodes in the grid. Expand Variables and Parameters: If the workflow uses a parameter file, the
PowerCenter Integration Service process sends the parameter file to the Data Transformation
Manager when it starts the DTM
67.Can we do ranking on two ports? If yes explain how?
Ans: No
68.What is Transformation?
Informatica Transformations are repository objects which can create, read, modifies, or passes data to
the defined target structures such as tables, files, or any other targets
69.What does stored procedure transformation do in special as compared to other transformation?
The Stored Procedure Transformation in Informatica helps you to use or call Stored procedures inside
the Informatica Workflow. Using this transformation, you can operate Drop or Recreate Indexes,
Check for Space in a Database, performing Complex Calculations.
70.How do you recognize whether the newly added rows got inserted or updated?
Just use debugger to know how the data from source moves to target, it will show how many new
rows get inserted else updated.
71.What is data cleansing?
Data cleaning is the process of fixing or removing incorrect, corrupted, incorrectly formatted,
duplicate, or incomplete data within a dataset
72.My flat file’s size is 400 MB and I want to see the data inside the FF with out opening it? How do I
do that?
use data preview in source or target

73.Difference between Filter and Router?

A Filter transformation tests data for one condition and drops the rows of data that do not meet the
condition. However, a Router transformation tests data for one or more conditions and gives you the
option to route rows of data that do not meet any of the conditions to a default output group..
74.How do you handle the decimal places when you are importing the flat file?
source ->number datatype port ->SQ -> decimal datatype. Integer is not supported. hence decimal is
taken care.
75.What is the difference between $ & $$ in mapping or parameter file? In which case they are
generally used?
$ means internal Parameter/Variable (such as $DBConnection prefix or $PMSessionLogDir) whereas
$$ are used for user-defined parameters or variables