Interested to Buy Any Domain ? << Click Here >> for more details...
explain different levels in pushdown optimization with example?
- 2 Answers
- 7228 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
What is the difference between informatics 7x and 8x and what is latest version?
How to configure mapping in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain lookup transformation source types in informatica
How to Create a folder using pmrep command?
What are the reusable transformations?
Differentiate between a database and data warehouse?
How do you load alternate records into different tables through mapping flow?
what is the hint? how to use it to reduce the query processing in program?
What are the components of Informatica? And what is the purpose of each?
What are the prerequisite tasks to achieve the session partition?
What is aggregator transformation in informatica?
Sequence generator, when you move from develoment to production how will you reset
Performance tuning in UNIX for informatica mappings?
What is the surrogate key?
