one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 6282 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 |
Can you copy the session to a different folder or repository?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
What are the differences between oltp and olap?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Why the workflow is failed after running two hours in informatica?
Explain lookup transformation is active in informatica
what is the difference between informatica6.1 and infomatica7.1
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
How do we implement materialized view?when to use materialized view?
how can you load data into target table without leading zeor's
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Teradata 
