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
How can you generate reports in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a predefined event?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the types of transformations?
What do you mean incremental aggregation?
What are the different ways to implement parallel processing in informatica?
How can repository reports be accessed without sql or other transformations?
can anyone explain me about retail domain project in informatica?
Performance tuning in UNIX for informatica mappings?
How can a transformation be made reusable?
Explain why we use partitioning the session in informatica?
Briefly define a session task?
How to use pmcmd utility command?
What is enterprise data warehousing?