IN GENERAL DATABASE OPERATONS ARE MORE FASTER THAT EXEXUTING IN THE POWER

What is 'PowerCenter Pushdown Optimization Option' in
INFORMATICA ?

Question Posted / rekha

5 Answers
19351 Views
I also Faced
E-Mail Answers

Answer Posted / rekha

IN GENERAL DATABASE OPERATONS ARE MORE FASTER THAT
EXEXUTING IN THE POWERCENTER,SO WE CAN MOVE THE COMPLEX
TRANSFORMATION LOGIC TO DATABASE FOR PERFORMNACE IMPROVE

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain sessions. Explain how batches are used to combine executions?

1042

Where can we find the throughput option in informatica?

1073

Can we override a native sql query within informatica?

1048

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1067

How many dimensions are there in informatica?

1101

Explain what are the different versions of informatica?

1109

What are the advantages of informatica?

1021

What is data movement mode in Informatica and difference between them?

1151

Can u generate reports in Informatica?

1099

Difference between Data and Index Caches?

1148

What is the surrogate key?

1276

what are the Methods For Creating Reusable Transformations?

1188

What are the guidelines to be followed while using union transformation?

1150

How can repository reports be accessed without sql or other transformations?

1235

What are the mapping parameters and mapping variables?

1211