What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?

Answer Posted / chanti

Genrally, data base opertions are more faster than
operations that are excuted under power center.

The main idea behind pushdown optmization is to push some
of the transformation logic to either source side or target
side data base, so that performance can be improved.

Is This Answer Correct ?    42 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Separate from an archive server and a powerhouse?

485


how we can load rejected record's at run time?(not through bad files)

1904


Tell me about MD5 functions in informatica

515


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1846


update strategy transformation in informatica

633






What is expression transformation?

623


Define enterprise data warehousing?

627


What are active transformations.

1181


What are pre and post-session shell commands?

729


How will the document be delivered to me?

611


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

623


What is confirmed fact in dataware housing?

5661


Which are the different editions of informatica powercenter that are available?

550


According to his methodology what all you need before you build a datawarehouse

1180


Mention some types of transformation?

600