explain different levels in pushdown optimization with example?
- 2 Answers
- 6437 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venubyna1
1. Source side push down
Integration service determine the T/r logic it ll send
as much as possible to source data base server
2.Target side push down
Integration service determine the T/r logic it ll send
as much as possible to targer data base server
3.fullside push down
Integration service determine the T/r logic it ll send
to source and target data base server
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain sessions?
Is there any target staging area in informatica not staging area
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to join three sources using joiner?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the differences between oltp and olap?
What are the types of data warehouses?
What is a surrogate key?
Why do we need informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is an aggregator transformation?
What are the different options available for update strategy?
Describe expression transformation?
Is stop and abort are same in informatica?
How to update a particular record in target with out running whole workflow?
