Answer / 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.

Answer / sudhar

Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.

Answer / 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

Answer / ashok1729

pushdown optimization will improve the performance of the
Load...

Let's see the E.g:

Sq ---> Flter_t ----> Target
[ sal<2000 ]

....

Answer / shiva

understanding the transfromatin language,and analize the
tranfromation language time being taken to achieve the
taske ,then push the trasnformtin logic either source
database or targer database.

What will be the approach?

0 Answers  

How to extract sap data using informatica?

0 Answers  

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

how to connect two or more table with single source qualifier?

4 Answers   IBM,

define galaxy repository in informatica

0 Answers  

Differentiate between reusable transformation and mapplet.

0 Answers  

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers