Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7269 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
Have you worked with/created Parameter file
How to configure mapping in informatica?
What are the different clients of powercenter?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How an expression transformation differs from aggregator transformation?
What are the different types of repositories created using informatica?
Briefly define reusable transformation?
How to do unit testing in informatica? How to load data in informatica ?
What are the differences between oltp and olap?
How can repository reports be accessed without sql or other transformations?
Can we change Dynamic to Static or Persistent cache? If so what happens?
In development project what is the process to follow for an etl developer from day1
What is exclusive and normal mode for repository services?
Implementation methodology
if we have a delimiters at unwanted places in a flat file how can we over come those.
