how to through logic of informatica using the push down
optimization into oracle.
- 2 Answers
- 6732 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 |
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
what is diffrence b/w joner and union transfermation
Design time, run time. If you don't create parameter what will happen
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Examples of Fatal & Non-Fatal error?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Why sorter is an active transformation?
What is the difference between normal and bulk loading? Which one is recommended?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
how can one eliminate dupliacte data with out using distinct option?
Teradata 
