Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7390 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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Whats there in global repository
Plz can any one say me how to get the informatica certification materials and dumps
Explain what are the different types of transformation available in informatica.
What is an expression transformation?
How can you differentiate between powercenter and power map?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
expain about the tune parameters?
How might one distinguish in the case of mapping is right or not without associating session?
What are the conditions needed to improve the performance of informatica aggregator transformation?
how many types of dimensions are available in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is blocking transformation?
permutations of mapplet
