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 |
Can we insert ,update ,delete in target tables with one update strategy tran.?
how to work with mapplet designer in informatica?
How can i send first half of the records to one target and Remaining to other target?
How you can differentiate between connected lookup and unconnected lookup?
what is mean by grouping of condition column in lookup transformation?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
How can u work with remote database in informatica?did you work directly by using remote connections?
In warehouses how many schemas are there?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?