Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain about cumulative Sum or moving sum?

975


Can we override a native sql query within informatica?

984


Explain load alternative records / rows into multiple targets - informatica

1096


What is lookup transformation?

1001


EXL informatica Questions

1309


Differentiate between router and filter transformation?

951


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?

1602


What is the reusable transformation?

1005


Can u generate reports in Informatica?

1024


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1027


What are the differences between oltp and olap?

914


What is intricate mapping?

1086


What is the Rank index port in Rank transformation?

1011


Performance tuning in UNIX for informatica mappings?

2503


How is union transformation utilized?

948