Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44648 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 ? | 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 |
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
What is the format of informatica objects in a repository?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is rank transform?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
In which circumstances that informatica server creates Reject files?
What are the guidelines to be followed while using union transformation?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
What is the function of aggregator transformation?
Teradata 
