Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?    40 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 ?    15 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

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,


How might you approve all mappings in the archive all the while?

0 Answers  


Explain pmcmd command usage in informatica

0 Answers   Informatica,


What is polling in informatica ?

1 Answers   TCS,


in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,






I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  


From where we can start or use pmcmd?

3 Answers  


What is data transformation manager process?

0 Answers  


What does refresh system mean, and what are its distinctive choice?

0 Answers  


I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,


Categories