Interested to Buy Any Domain ? << Click Here >> for more details...
What is target update override
- 2 Answers
- 7662 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / usha
target update override which is used to update the data
with out using UPDATE transformation....
if there is no PK in the target we can update by using
target update override
| Is This Answer Correct ? | 1 Yes | 0 No |
what are challenges that you faced in testing? give solution to it?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what is inline view?
What is the surrogate key?
can we generate reports in informatica ? How?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
Explain the code page compatibility?
What are the phases in SDLC?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is a configuration management?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
Teradata 
