How do you create single lookup transformation using
multiple tables?

Answer Posted / kalyan

we have the lOOKUP OVERRIDE Query in the Lookup
transformation. Use the SQl Query to join the tables you
lookup on. Thsi is similar to what yo do at the Source
Qualifier

Is This Answer Correct ?    42 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different lookup cache(s)?

618


Enlist the tasks for which source qualifier transformation is used.

587


Different sorts of metadata that stores in the storage facility?

555


How to implement security measures using repository manager?

601


Explain what is informatica metadata and where is it stored?

605






What is the different lookup cache(s)?

610


How we can create indexes after completing the load process?

613


What are the reusable transformations?

696


Differences between connected and unconnected lookup?

609


What is a transaction control transformation?

762


How do you manage the Parameter files while migrating your data from one environment to another environment?

541


What is joiner transformation?

584


server hot-ws270 is connect to Repository B. What does it mean?

1853


Could you explain what is enterprise data warehouse?

552


How many ways a relational source definition can be updated and what are they?

576