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

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

1328


explain abt ur project architecture?

1751


What is informatica metadata and where is it stored?

575


Explain the types of transformations?

591


What is Data Caches size?

650






write a query to retrieve the latest records from the table sorted by version(scd)

625


Explain lookup transformation in informatica

640


What are Dimensional table?

599


What is dimensional table?

614


EXL informatica Questions

920


What are the new features of informatica 9.x at the developer level?

593


When do you use sql override in a lookup transformation?

575


Why is sorter an active transformation?

656


How do you load only null records into target?

731


What is decode in static cache?

584