how to through logic of informatica using the push down
optimization into oracle.
- 2 Answers
- 6714 Views
- Hexaware, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / varun4db
For source side we can push by overriding the query..so that
integration service pass the query to database... Please
correct me if am wrong..!!!
| Is This Answer Correct ? | 4 Yes | 0 No |
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 |
what is mystery dimension?
scenario
what is meant by data driven.. in which scenario we use that..?
What is union transformation?
What is parallel processing in informatica?
what are objects in data warehouse?
How to differentiate between the active and passive transformations?
how to call lookup qualifer in unconnected look;up
how we load the data from source to staging area
What are the components of Informatica? And what is the purpose of each?
can we have to do changes in session property when we are dynamically generating target files?
Mention some types of transformation?
Teradata 
