one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7666 Views
- Polaris, I also Faced
- E-Mail Answers
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 |
How to eliminate duplicates from flat file..what is the procedure
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is persistent lookup cache?
While migrating the data from one environment to another environment how would you manage the connections?
Target increases every day even though no new record was inserted
How to elaborate powercenter integration service?
Enlist some properties of sessions.
What are the new features in Informatica 5.0?
Informatica and datawarehousing courses in Pune?
What is meta data and system catalog?
Which transformation should we use to normalise the COBOL and relational sources?
How to improve the performance of Aggregate transformation?
Teradata 
