Interested to Buy Any Domain ? << Click Here >> for more details...
How do you create single lookup transformation using
multiple tables?
- 6 Answers
- 44371 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
What is the difference between informatica 7.0 and 8.0?
how many types of dimensions are available in informatica?
Which files are created during the session rums by informatics server?
can you please explain me pre session and post session options?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
how tokens will generate?
have u done any performance tuning? how u ll do?
where to store informatica rejected data? How to extract the informatica rejected data?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is a repository manager?
What are the tasks that source qualifier perform?
How we can use union transformation?
Can we create a Integration service without a Repository service and vice versa?
How to create a non-reusable instance of reusable transformations?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
