explain different levels in pushdown optimization with example?
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
What is complex mapping?
Mention some types of transformation?
How to update or delete the rows in a target, which do not have key fields?
In which transformation you cannot drag ports into it?
What are the steps involved in the migration from older version to newer version of Informatica Server?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the designer tools for creating transformations?
What is InformaticaPowerCenter?
According to his methodology what all you need before you build a datawarehouse
Differentiate between joiner and lookup transformation?
have u done any performance tuning? how u ll do?
What are the different transaction levels available in transaction control transformation?
What are junk dimensions?
What could be the possible resons of locks by user?
What is dynamic cache?