What is a look up function? What is default transformation
for the look up function?
Answer Posted / guest
look up compares the source to target.it update and insert
the new rows to the target.
the default transformation for look up is source qualifier
Is This Answer Correct ? | 13 Yes | 9 No |
Post New Answer View All Answers
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.
Enlist some properties of sessions.
What is the function of look up transformation?
Define update strategy?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to extract sap data using informatica? What is abap? What are idocs?
During the running session, output files are created by informatica server. Enlist few of them.
Explain lookup transformation in informatica
Explain informatica architecture - version 8 / 9
Define the various join types of joiner transformation?
How to Create a folder using pmrep command?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the scenario which compels informatica server to reject files?
Explain lookup transformation source types in informatica
What are the settings that you use to configure the joiner transformation?