how to through logic of informatica using the push down
optimization into oracle.
Answer Posted / venubyna1
Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which transformation is needed while using the Cobol sources as source definitions?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the new features of Power Center 5.0?
What is domain and gateway node?
How do you change a non-reusable transformation to reusable transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
What the difference is between a database, a data warehouse and a data mart?
Enterprise data warehouse your projects phase by phase explain?
What is the difference between informatica 7.0 and 8.0?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can we remove the duplicates from flat file source?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What do think which one is the better joiner or look up?