Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7371 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
How to join three sources using joiner?
How to create Target definition for flat files?
What is the use of code page?
lookup transformation with screenshots
What is workflow manager?
How to create the source and target database connections in server manager?
What is a filter transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do you understand by SOA of Informatica?
What is main use of mapplet?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the types of lookup transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
without table how to come first record only in oracle?
