How we will implement Pushdown Optimization and Types in Informatica with better examples

Answer Posted / abhinaw prakash

Just to add on the above points.We cannot decide which
transofrmation logic to send to the Database.The
integrations service decides which login to send to the
database to optimize the process.although we can see the
sql logic in the Pushdown priview and the messages and
warning attached to it.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How union transformation is used?

600


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1707


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

606


What is Index Caches size?

629


What is the command used to run a batch?

583






what is unit testing?tell me proceedure

1794


What is the maplet?

628


Which transformation should we use to normalise the COBOL and relational sources?

753


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1764


How do you update the records with or without using update strategy?

676


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

762


What is an active transformation?

653


explain one complex mapping with logic? sales project?

6163


Different qualification between a related rotate toward the sky and isolates look upward?

564


Explain sessions and how many types of sessions are there?

594