one source to target loading insert new rows and update
existing rows?
Answers were Sorted based on User's Feedback
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 |
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 |
What is a design?
Have you worked with/created Parameter file
What is sql query override? When did u use sql query override?
Write the unconnected lookup syntax?
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?
Could you explain what is enterprise data warehouse?
Quickly characterize reusable change?
Why we select the table which has minimum number of records as Master table in joiner?
What is the maplet?
HOW TO GET THE LATEST DATA IN SCD ?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
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