one source to target loading insert new rows and update
existing rows?

Answers were Sorted based on User's Feedback



one source to target loading insert new rows and update existing rows?..

Answer / s

We can achieve this

SRC->EXP->UPD->TGT.

In Update Transformation put DD_UPDATE. And in target add
update_override to update the required columns based on the
condition. At session level set the target load attribute
as INSERT, UPDATE ELSE INSERT.

Is This Answer Correct ?    5 Yes 0 No

one source to target loading insert new rows and update existing rows?..

Answer / jay

SQ ---------> UPD --> TRG
| ^
| |
--> LKP --

In update startegy, just give type as formula
iif(isnull(LKP_Col1), 0, 1)

0 --> DD_INSERT
1 -->DD_INSERT

Is This Answer Correct ?    4 Yes 1 No

one source to target loading insert new rows and update existing rows?..

Answer / ppl

using scd type 2 v can do dis

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is a design?

1 Answers  


Have you worked with/created Parameter file

0 Answers  


What is sql query override? When did u use sql query override?

1 Answers   TCS,


Write the unconnected lookup syntax?

0 Answers  


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  


Could you explain what is enterprise data warehouse?

0 Answers  


Quickly characterize reusable change?

0 Answers  


Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,


What is the maplet?

0 Answers   Informatica,


HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,


Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  


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

8 Answers   HP,


Categories