Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7287 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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
can you please explain me pre session and post session options?
What is different between the data warehouse and data mart?
What are the designer tools for creating transformations?
How to create or import flat file definition in to the warehouse designer?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is repository manager?
Describe expression transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How might you approve all mappings in the archive all the while?
Can you use flat files in Mapplets.
How to join three sources using joiner? Explain though mapping flow.
I have a flat file, want to reverse the contents of the flat file
Sequence generator, when you move from develoment to production how will you reset
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
