Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7295 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 call shell scripts from informatica?
How can we improve session performance in aggregator transformation?
What are the popular informatica products?
tell me the rules and responsblites in our project(my project is development)
What is an unconnected transformation?
What is the use of source qualifier?
What is the reusable transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is the difference between writing a joiner query in ANSI style and THETA style?
How many transformations can be used in mapplets.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the pipeline partition with real time example?
list out all the transformations which use cache?
What is substr in informatica?
