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

lookup transformation with screenshots

1 Answers   TCS,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

what is the difference between stop and abort?

3 Answers   TCS,

diffrence between command task and control task

1 Answers   iNautix,

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

design of staging area?

1 Answers  

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

In joiner, how to load Master table in Target?

2 Answers  

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

For more Informatica Interview Questions Click Here
Categories