How do you create single lookup transformation using
multiple tables?

Answers were Sorted based on User's Feedback



How do you create single lookup transformation using multiple tables?..

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

How do you create single lookup transformation using multiple tables?..

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

How do you create single lookup transformation using multiple tables?..

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

How do you create single lookup transformation using multiple tables?..

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

How do you create single lookup transformation using multiple tables?..

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

How do you create single lookup transformation using multiple tables?..

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

Post New Answer

More Informatica Interview Questions

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


How to load last n records of file into target table - informatica

0 Answers   Informatica,


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


How to display null values on a target & non-null values on a target?

3 Answers  


hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


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

2 Answers   TCS,


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  


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?

2 Answers  


How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  


Define Pmrep command?

0 Answers  


Categories