how to through logic of informatica using the push down
optimization into oracle.
- 2 Answers
- 6764 Views
- Hexaware, I also Faced
- E-Mail Answers
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
Explain Dataware house architecture .how data flow from intial to end?
What are the differences between oltp and olap?
Do you find any difficulty while working with flat files as source and target?
What do you mean incremental aggregation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How is union transformation utilized?
How do you load unique records into one target table and duplicate records into a different target table?
what is degenerated dimension?
how tokens will generate?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the advantages of informatica?
What are pre and post-session shell commands?
can we override a native sql query within informatica? Where do we do it? How do we do it?
