one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 6017 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
Explain incremental aggregation in informatica
what is index?how it can work in informatica
What is source qualifier transformation in informatica?
How to update source definition?
is it possible to index the data in cache of lkp transformation ?
What is flashback table ? Advance thanks
What is a pre-defined event and user-defined event?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the different lookup cache(s)?
What are the designer tools for creating transformations?
What is an expression transformation?
what are the deliverables?in your project?
How does a rank transform differ from aggregator transform functions max and min?
Design a mapping to load a target table with the following values from the above source?
