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.

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

What is mapping debugger?

0 Answers  

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

What is event and what are the tasks related to it?

0 Answers  

Repository user profiles

0 Answers  

What is the Difference between sorter and aggregator?

2 Answers  

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

What are the different threads in DTM process?

2 Answers  

How big was your fact table

0 Answers