Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7167 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
How do you use reject loader.
Describe the impact of several join conditions and join order in a joiner transformation?
What do you mean by filter transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is complex mapping?
How to load the data from a flat file into the target where the source flat file name changes daily?
Is it possible to define a single node as a Gateway node as well as worker node?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
how to load dimension table and fact table. plz tell me the steps.
Mention few power centre client applications with their basic purpose?
How identifying bottlenecks in various components of informatica and resolving them?
Why update strategy and union transformations are active?
What is the use of source qualifier?
What are connected or unconnected transformations?
How do you change a non-reusable transformation to reusable transformation?
