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

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

Question Posted / dinesh

3 Answers
7342 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

why we are using level option in normalizer transformation

1 Answers TCS, Wells Fargo,

Explain pmcmd command usage in informatica

0 Answers Informatica,

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers HP,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 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,

What is deployment group?

0 Answers

how do u move the code from development to production?

6 Answers

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers Accenture,

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers ITC Infotech, TCS,

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers HGS, TCS,

Can i create a lookup table without cache.

7 Answers iGate,

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers

For more Informatica Interview Questions Click Here