Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7161 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 |
what is diff between grep and find
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
What is a sequence generator transformation?
How to update a particular record in target with out running whole workflow?
where does the default group roew in a router is stored what is the default size of memory in router
Is snow flake or star schema used? If star schema means why?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
How does the session recovery work.
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Performance tuning( what you did in performance tuning)
How big was your fact table
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Teradata 
