Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44622 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
Explain pmcmd command usage in informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
What is union transformation in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is decode in static cache?
What is a dimensional model?
What is deployment group?
What is the function of union transformation?
whats the logic to load the lower level of granularity of data to fact table.
What are the new features of Power Center 5.0?
Describe expression transformation?
Performance tuning in UNIX for informatica mappings?
How would you copy the content of one repository to another repository?
How to load the data from a flat file into the target where the source flat file name changes daily?
