How do you create single lookup transformation using
multiple tables?
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 |
write a query to retrieve the latest records from the table sorted by version(scd)
How to load last n records of file into target table - informatica
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How to display null values on a target & non-null values on a target?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
How might one distinguish in the case of mapping is right or not without associating session?
Define Pmrep command?