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

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,


tell me about your project functionality

0 Answers  


pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


what is the difference between stop and abort?

3 Answers   TCS,


What do you mean incremental aggregation?

0 Answers  


what is incremental aggregation ,with example?

2 Answers  


How to delete duplicate row using informatica?

0 Answers  


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,


we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  


How can we handle two sessions in informatica?

0 Answers  


Can we make worklet inside worklet?

1 Answers  


Categories