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 do you load alternate records into different tables through mapping flow?
Explain the different kinds of facts.
Enlist the differences between database and data warehouse.
How do you load first and last records into target table?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How can we remove the duplicates from flat file source?
How to create or import flat file definition in to the warehouse designer?
explain abt ur project architecture?
draw informatica architecture 8.6 ?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to load the data from people soft hrm to people soft erm using informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the different types of repositories created using informatica?