Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / mehul.thakur


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

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

what is the difference between mapplet & stored procedure?

1 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

What is update strategy transform?

0 Answers  

What is power play plug in?

2 Answers  

what is mean by complex business rule ?

0 Answers   Cap Gemini,

what is mapping performence?

2 Answers   Cap Gemini,

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

For more Informatica Interview Questions Click Here
Categories