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
how many types of dimensions are available in informatica?
Explain sessions and how many types of sessions are there?
What is confirmed fact in dataware housing?
What are the new features of Power Center 5.0?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How can we use mapping variables in informatica? Where do we use them?
Is it possible to revert a global repository to local one and why?
What is decode in static cache?
generate date / time dimension in informatica
What are the main features of Oracle 8i with context to datawarehouse?
Is it possible to define a single node as a Gateway node as well as worker node?
What is deployment group?
What are the reusable transformations?
server hot-ws270 is connect to Repository B. What does it mean?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?