how to create a sample mapping for dynamic lookup
transformation
- 2 Answers
- 4566 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is semi-additive fact?where did u used?
Can we update the data in flat file using update strategy?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
how to get flatfile containg 10 records half records one target another half another target
what are surrogate keys?
As union transformation gives UNION ALL output, how you will get the UNION output?
How can we improve session performance in aggregator transformation?
How to delete the (flat file) data in the target table after loaded.
Explain about the concept of mapping parameters and variables ?
What are connected or unconnected transformations?
Different circumstance which drives informatica server to expel records?
what is update strategy transformation ?
Teradata 
