Interested to Buy Any Domain ? << Click Here >> for more details...
how to through logic of informatica using the push down
optimization into oracle.
- 2 Answers
- 7736 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 the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
What is Java Transformation? what are the uses of it?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
What is a candidate key?
what are the types of facts with Examples?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is persistent lookup cache?
What is lookup change?
Describe data concatenation?
What are session parameters ? How do you set them?
What are the tuning techniques you applied during your last project
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
Teradata 
