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
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Why is sorter an active transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Is stop and abort are same in informatica?
Explian the Process of deployment groups in informatica
Global and Local shortcuts. Advantages.
What is the difference between router and filter?
Design time, run time. If you don't create parameter what will happen
What is aggregator transformation in informatica?
What is meant by lookup transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the function of aggregator transformation?
Performance tuning in UNIX for informatica mappings?
In warehouses how many schemas are there?