explain different levels in pushdown optimization with example?
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
difference between repository database and repository service?
How to implement security measures using repository manager?
What is update strategy transform?
Informatica Checkpoints
Explain pushdown optimization and types in informatica
What is a code page?
Differentiate between source qualifier and filter transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the informatica performance improvement tips
How are indexes created after completing the load process?
What is session task and command task?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What does role playing dimension mean?
tell me the rules and responsblites in our project(my project is development)
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