Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44306 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 ? | 43 Yes | 2 No |
Answer / 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 |
Answer / bsgsr
join the tables in the database itself then do the look up
else override the lookup sql and look up.
i believe this would work.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / latha
Lookup transformation: Based upon one/more keys the data is
retreived from one/more tables.
create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.
| Is This Answer Correct ? | 10 Yes | 8 No |
Answer / koti
Re: How do you create single lookup transformation using
multiple tables?
Answer
# 1 Lookup transformation: Based upon one/more keys the
data is
retreived from one/more tables.
create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.
| Is This Answer Correct ? | 3 Yes | 6 No |
Answer / murali vishnuvajhala
you cannot join two tables in a lookup. Lookup works only
on one underlying table.
| Is This Answer Correct ? | 4 Yes | 34 No |
Is it possible to use a client with different version than that of its Informatica server?
What is the maplet?
What are the modules in Power Center
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
what is the difference between Informatica7.1 & informatica 8.1
Explain scd type 3 through mapping.
What is the difference between informatics 7x and 8x and what is latest version?
is it possible to index the data in cache of lkp transformation ?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
What are the types of metadata that stores in repository?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
Teradata 
