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...

there is a mapping with expression and mapping we create
some condition for insert and update and followed by update
startegy ,can we update and insert on a single target based
on condition?

Answer Posted / gm

Yes, We can do both in Update Startegy,
SOURCE-SQ-EX-LKP-UPD-TAGET

In Update Startegy IIF(ISNULL(EMPID),DD_INSERT,DD_UPDATE)

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to join three sources using joiner?

1050


How are indexes created after completing the load process?

1571


What is data caches/ index caches?

1035


What is native users?

1110


Explain how to import oracle sequence into informatica?

968


In how many ways we can create ports?

1081


what is $$$$?

2107


What do you mean incremental aggregation?

1032


Explain about Informatica server process that how it works relates to mapping variables?

1029


What do you mean by worklet?

1032


Why update strategy and union transformations are active?

1003


Explain your project of banking domian.

1619


What is meant by lookup transformation?

1051


Repository user profiles

1725


Do you find any difficulty while working with flat files as source and target?

1063