How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 41491 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 ? | 42 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 |
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
Can you create a flatfile target
If u select groupby port in aggregator what is output and dont select groupby option what is output
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
How do you load unique records into one target table and duplicate records into a different target table?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
Write the different tools in the workflow manager?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is IQD file?
can we create index and drop index in exsisting table while using infomatica
Define Update Override?
Teradata 
