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
What is a filter transformation?
What are the different types of transformation available in informatica.
how to load dimension table and fact table. plz tell me the steps.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are junk dimensions?
What is meant by pre and post session shell command?
Where is metadata stored?
What are the designer tools for creating transformations?
Can we create two repositories on same database instance in oracle?
Explain incremental aggregation in informatica
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is an Integration service in Informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
can we override a native sql query within informatica? How do we do it?