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
- 7794 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 |
Is there any model difference between ODS and DWH
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
which one is better either active or passive transformation in informatica
Difference between task flow and linear task flow
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
can we have to do changes in session property when we are dynamically generating target files?
how to design mapping half of source table records into one target and remaining half into another target
comonly how meny mappings r there in Banking projects?
how to get the only updated records in the target
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
how eliminate the duplicates in flat file with out using sorter ,aggregater
Teradata 
