How do you create single lookup transformation using
multiple tables?
Answer Posted / murali vishnuvajhala
Apologies for giving wrong answer in the past (Answer #4)
You can actually join multiple tables in the lookup.
Here are the steps.
1. Click on Lookup transformation
2. Click on "Skip" button to the right
3. A green Lookup Transformation will apprear without any
ports.
4. Put your query in the SQL Override.
5. Make sure you specify the columns you selected in your
query as ports IN THE SAME ORDER
6. Your lookup is ready
NOTE: When you specify the query make sure you specify
column alises for each column.... else you will get invalid
lookup error during run time.
Good Luck!
Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Define enterprise data warehousing?
Describe the impact of several join conditions and join order in a joiner transformation?
What is a node in Informatica?
Can anyone tell me the new features in Informatica 9 Version?
What is decode in static cache?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a shortcut and copy in Informatica and how two are different with each other?
How to elaborate tracing level?
Why is sorter an active transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is meant by active and passive transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is Data Caches size?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different types of repositories created using informatica?