tell me the push down optimization
Answers were Sorted based on User's Feedback
Answer / nagaraju
push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akhil4
this option available in session(work flow) properties.
it increase informatica server performance.
when ever u enable this option it created view in database related to logic.(MEANS YOU TAKEN SEVERAL T/R IN THIS U HAVE IMPLEMENTED LOGIC USING THAT LOGIC IT WILL CREATE A VIEW)
U START WF IT TAKE THE DATA DIRECTLY TO SQ AND PUSH DATA THROUGH LOGIC AND LODES INTO TARGET.
Is This Answer Correct ? | 0 Yes | 3 No |
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
What does role playing dimension mean?
major difference between normal loading and bulk loading?
Mention some types of transformation?
what is metadata?
guys which is the best institute in banglore to learn informatica??
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Target is zero file and how can you send the email?
Without using Lookup & Sequence Generator, How to generate Sequence?
what is a transforamation?
Global and Local shortcuts. Advantages.
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve