how to create a sample mapping for dynamic lookup
transformation
- 2 Answers
- 4317 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
What is Session and Batches?
What are the different options available for update strategy?
What is the cumulative sum and moving sum?
How can we use batches?
What is option by which we can run all the sessions in a batch simultaneously?
Define pmcmd command?
What is target load order?
What can we do to improve the performance of informatica aggregator transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can you generate sequence numbers without using the sequence generator transformation?
What is the Process to creating lookup transformation in informatica
What are the performance considerations when working with aggregator transformation?
How to differentiate between the active and passive transformations?
Write the unconnected lookup syntax and how to return more than one column.
