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
- 7793 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 |
How can you define user defied event?
what is INFORMATICA TESTING process
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What do you mean by worklet?
How the informatica server increases the session performance through partitioning the source?
How do you convert single row from source into three rows into target?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What is deployemnt groups, Lables, query and dynamic deployment group.
explain different types of modeling.
What is Target Update Override? What is the Use ?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
What if the source is a flat-file?
Teradata 
