How do you create single lookup transformation using
multiple tables?
Answer Posted / 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 |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
How will the document be delivered to me?
What are the components of Informatica? And what is the purpose of each?
What is a standalone command task?
update strategy transformation in informatica
What are the main features of Oracle 8i with context to datawarehouse?
tell me about your project functionality
What is the Rank index port in Rank transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is a pre-defined event and user-defined event?
What are the new features of informatica 9.x at the developer level?
Explain pushdown optimization and types in informatica
How can a transformation be made reusable?
What is difference between a gateway node and worker node?