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
- 7804 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 confirmed dimension?
What is difference between maplet and reusable transformation?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
what is procedure to use mapping variable in source qualifier transformation? with example
Why we use lookup transformations?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
What is limitations of truncate and load option
Howmany ways yoU can update a relational source defintion and what are they?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Teradata 
