One of the optimizing technique to improve the session
performance is push down optimization,by using push down
optimization we push as much as transformation logic to
source/target database,but this degrades the d/b
performance,how to overcome this?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,


How many cubes create from a single model?

1 Answers  


I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  


If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,


Is there any model difference between ODS and DWH

2 Answers   Zensar,






Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,


How does the aggregator transformation handle null values?

0 Answers  


How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  


what is workflow varible

1 Answers   HP,


What are the active and passive transforamtions?

2 Answers  


What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  


wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,


Categories