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

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


What are differences between Informatica 7.1 and 6.1

3 Answers  


How can you validate all mappings in the repository simultaneously?

0 Answers  


i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,


can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


How many numbers of sessions can one group in batches?

0 Answers  


How the dimensions will be loaded?

0 Answers   HCL,


Categories