Answer Posted / 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 |
Post New Answer View All Answers
What is intricate mapping?
Parameter and variable differences
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain load alternative records / rows into multiple targets - informatica
What is blocking transformation?
Why update strategy and union transformations are active?
without table how to come first record only in oracle?
How many ways are there to do 'remove duplicate records in informatica'?
What is exclusive and normal mode for repository services?
Explain informatica architecture - version 8 / 9
Tell me about Propagate functions in informatica
What is a rank transform?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain about cumulative Sum or moving sum?
what is song in infrmatica...?
