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?



there is a mapping with expression and mapping we create some condition for insert and update and f..

Answer / 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

More Informatica Interview Questions

Explain sessions and how many types of sessions are there?

0 Answers  


Explain why we use partitioning the session in informatica?

0 Answers  


how to load only the first and last record of a flat file into the target?

8 Answers   CTS,


(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  


how do u move the code from development to production?

3 Answers  


what is degenerated dimension

6 Answers   Cap Gemini,


What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


What is meant by pre and post session shell command?

0 Answers  


How can repository reports be accessed without sql or other transformations?

0 Answers  


What is rank transformation?

0 Answers  


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


Categories