what is work of PUSH DOWN option

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


Please Help Members By Posting Answers For Below Questions

How can we update a record in the target table without using update strategy?

658


What do you mean by channel change?

545


What are some examples of informatica etl programs?

538


How can we improve session performance in aggregator transformation?

674


What are the differences between oltp and olap?

552






i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702


What is a sequence generator transformation?

577


Sequence generator, when you move from develoment to production how will you reset

1412


What are connected or unconnected transformations?

630


What is decode in static cache?

596


In informatics server which files are created during the session rums?

639


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

699


Is it possible to revert a global repository to local one and why?

615


How do you change a non-reusable transformation to reusable transformation?

600


Name the different lookup cache(s)?

711