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


Please Help Members By Posting Answers For Below Questions

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.

1261


Enlist some properties of sessions.

634


What is the function of look up transformation?

653


Define update strategy?

641


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1660






How to extract sap data using informatica? What is abap? What are idocs?

560


During the running session, output files are created by informatica server. Enlist few of them.

544


Explain lookup transformation in informatica

648


Explain informatica architecture - version 8 / 9

671


Define the various join types of joiner transformation?

561


How to Create a folder using pmrep command?

626


Design a mapping to load the cumulative sum of salaries of employees into target table?

900


What is the scenario which compels informatica server to reject files?

607


Explain lookup transformation source types in informatica

702


What are the settings that you use to configure the joiner transformation?

614