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 can u insert o ne row in the target if that row does not
exists in the target and update if it exists

Answer Posted / sailu

Do look up on the target with the key values. Check if the
look up is null or not. If look up value is null insert it
and if look up value is not null update it using update
strategy transformation with DD_UPDATE

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is mean by complex business rule ?

2108


What is a shortcut and copy in Informatica and how two are different with each other?

1130


Define joiner transformation?

986


What is target load order?

1186


What is the use of code page?

1010


How might you approve all mappings in the archive all the while?

956


Performance tuning in UNIX for informatica mappings?

2506


How can we store previous session logs?

989


where to store informatica rejected data?

1046


What is intricate mapping?

1091


Mention few advantages of router transformation over filter transformation.

982


Which version configuration tool used in ur project?

3181


Which transformation should we use to normalise the COBOL and relational sources?

1141


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1047


What is a dimensional model?

927