Interested to Buy Any Domain ? << Click Here >> for more details...
how to create a sample mapping for dynamic lookup
transformation
- 2 Answers
- 5093 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
when you use dynamic lookup t/r a new row will be added to the lookup(lookup row port).
Use a router for insert and update.
have 2 update strategy t/r and give the xpression lookuprow port as 1(insert) and 2(update).
connect it to the target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where is metadata stored?
Different qualification between a related rotate toward the sky and isolates look upward?
Have you worked with/created Parameter file
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 the difference between writing a joiner query in ANSI style and THETA style?
What are the differences between source qualifier and joiner transformation?
Define Pmrep command?
Does an informatica transformation support only aggregate expressions?
which one is better performance wise joiner or look up
What is domain and gateway node?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is decode in informatica?
Write the prerequisite tasks to achieve the session partition?
Enlist the differences between database and data warehouse.
How do you load alternate records into different tables through mapping flow?
