How can u insert o ne row in the target if that row does not exists in the targ

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

How can u insert o ne row in the target if that row does not
exists in the target and update if it exists

Question Posted / guest

6 Answers
12754 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / sudhar

Use the session properties,
In Target Properties use options
Insert
update else Insert
Check boxes.

Is This Answer Correct ?

15 Yes

1 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / sujana

by using scd type2 v can do dis

Is This Answer Correct ?

9 Yes

3 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / abhinav

By using an UPDATE STARTEGY transformation.

DD_UPDATE = If the record alreadye exists

DD_INSERT = If the record is a new one

Is This Answer Correct ?

4 Yes

2 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / suresh

scd type 2

Is This Answer Correct ?

1 Yes

0 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / sailu

Do look up on the target with the key values. Check if the
look up is null or not. If look up value is null insert it
and if look up value is not null update it using update
strategy transformation with DD_UPDATE

Is This Answer Correct ?

1 Yes

0 No

How can u insert o ne row in the target if that row does not exists in the target and update if it ..

Answer / chandrasekar

Hi Sudhar,

Please check your answer it is not working....

We can use the SCD type 1 only get the new row as insert
into target and updated record as update into target.

If it wrong means please mail me.. chandranmca2007@gmail.co

Is This Answer Correct ?

0 Yes

0 No

Post New Answer