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 in detail scd type 2 through mapping.

0 Answers  


how can import the data from the flat files?

2 Answers  


whatis the default data driven operation in informatica

2 Answers  


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,


What are the types of maping wizards that r to be provided in Informatica?

2 Answers  






How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,


In a sequential batch can u run the session if previous session fails?

3 Answers  


What is workflow manager?

0 Answers  


What is resilience time?

0 Answers  


Explain joiner transformation in informatica

0 Answers   Informatica,


How union transformation is active ?

2 Answers   Puma,


in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


Categories