Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44260 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do we call shell scripts from informatica?
In warehouses how many schemas are there?
How big was your fact table
What is meant by a domain?
What is data movement mode in Informatica and difference between them?
What is decode in informatica?
Enlist some properties of sessions.
Where are the source flat files kept before running the session?
How can we create index after completion of load process?
Is it possible to create multiple domains on a single Informatica server?
What is dimensional table? Explain the different dimensions.
What is joiner transformation?
Explain how to import oracle sequence into informatica?
Write the prerequisite tasks to achieve the session partition?
Can anyone tell me the new features in Informatica 9 Version?
