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
- 7740 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 |
Explain in detail about scd type 1 through mapping.
How to Join Tables my Source is having 15 table target is one?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Explain about Informatica server process that how it works relates to mapping variables?
What is a command that used to run a batch?
What are the basic needs to join two sources in a source qualifier?
How is Data Models Used in Practice?
Informatica settings are available in which file?
Is it possible to revert a global repository to local one and why?
what are the types of Data warehousing ?
What is the difference between Bulk Load and Normal Load
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Teradata 
