there is a mapping with expression and mapping we create some condition for ins

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

1 Answers
4823 Views
Emphasis, I also Faced
E-Mail Answers

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

Differentiate between mapping parameter and mapping variable?

1 Answers

What is a repository? And how to add it in an informatica client?

0 Answers Informatica,

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers HP,

What is a unit Testing?

1 Answers

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers iGate,

What are the different types of repositories created using informatica?

0 Answers

Define update strategy?

0 Answers

what is incremantal aggregation?

1 Answers

what is the logic will you implement to load data into a fact table from n dimension tables?