tell me the push down optimization

Answer Posted / nagaraju

push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create two repositories on same database instance in oracle?

705


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

901


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1422


what is INFORMATICA TESTING process

1943


Is it possible to create multiple domains on a single Informatica server?

869






What is repository manager?

632


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1792


What are active and passive transformations?

724


Why union transformation is an active transformation?

751


have u done any performance tuning? how u ll do?

1961


What is an active transformation?

739


How to extract sap data using informatica?

692


Explain lookup transformation in informatica

736


Write the different tools in the workflow manager?

662


Define joiner transformation?

672