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
r u done any partitions in ur project?
How can we handle two sessions in informatica?
What is xml source qualifier transformation in informatica?
What do you understand by SOA of Informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How does a sorter cache works?
Explain load alternative records / rows into multiple targets - informatica
Explain why we use partitioning the session in informatica?
What is the command used to run a batch?
What are the types of schemas we have in data warehouse.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How will the document be delivered to me?
Clarify the utilization of aggregator cache record?
Explain informatica architecture - version 8 / 9
Repository user profiles