how to create a sample mapping for dynamic lookup
transformation
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
Explain about cumulative Sum or moving sum?
Can we override a native sql query within informatica?
Explain load alternative records / rows into multiple targets - informatica
What is lookup transformation?
EXL informatica Questions
Differentiate between router and filter transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the reusable transformation?
Can u generate reports in Informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the differences between oltp and olap?
What is intricate mapping?
What is the Rank index port in Rank transformation?
Performance tuning in UNIX for informatica mappings?
How is union transformation utilized?