Answer Posted / kapil
The Pushdown Optimization Option improves performance by
enabling processing to be “pushed down” to a
relational database, maximizing fl exibility, minimizing
unnecessary data movement, and providing the optimal
performance for both data-intensive and process-intensive
transformations.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
Have you worked with/created Parameter file
What is a filter transformation and why it is an active one?
How do you convert single row from source into three rows into target?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Why sorter is an active transformation?
What is union transformation?
What is a transaction control transformation?
can we override a native sql query within informatica? How do we do it?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Is there any target staging area in informatica not staging area
What is DR strategy for Informatica project?
What is a difference between complete, stop and abort?
What is the function of look up transformation?
What are connected or unconnected transformations?