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
- 7734 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
What are multi-group transformations?
Does an informatica transformation support only aggregate expressions?
What is the difference between a connected look up and unconnected lookup?
Sequence generator, when you move from develoment to production how will you reset
can you please explain me pre session and post session options?
What is pmcmd command?
What you know about transaction control transformation?
Define the various join types of joiner transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Differentiate between joiner and lookup transformation?
what is the Default Source Option For Update Strategy Transformation?
Can you use flat files in Mapplets.
Explain scd type 3 through mapping.
Define sessions in informatica etl?
Separate from a database, an information bazaar, and an information stockroom?
