Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7189 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / praveen hattikal
pushdown optimization: way of load balancing among the
servers to achieve optimal performance
Veteran ETL developers often come across issues when they
need to determine the appropriate place to perform ETL
logic. Suppose an ETL logic needs to filter out data based
on some condition. One can either do it in database by
using WHERE condition in the SQL query or inside
Informatica by using Informatica Filter transformation.
Sometimes, we can even "push" some transformation logic to
the target database instead of doing it in the source side
(Especially in the case of EL-T rather than ETL). Such
optimization is crucial for overall ETL performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
How to extract sap data using informatica?
What is fact table? Explain the different kinds of facts.
what is the -ve test case in your project.
Briefly explain the aggregator transformation?
Target increases every day even though no new record was inserted
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the commit type if you have a transaction control transformation in the mapping?
What is sorter transformation?
What is the reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Where can we find the throughput option in informatica?
Reusable transformation and shortcut differences
How many ways a relational source definition can be updated and what are they?
