What is target update override
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 |
When do you use mapping parameters? (In which transformations)
what is diff b/t sorter t/r and agg have the option sorter property...
How to use procedural logic inside infromatica?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
in which situations do u go for snowflake schema ?
Explain direct and indirect flat file loading (source file type) - informatica
Enlist the tasks for which source qualifier transformation is used.
What is transformation?
Is there any target staging area in informatica not staging area
how we load the data from source to staging area
HOW TO GET THE LATEST DATA IN SCD ?
If I have a index defined on target table and if set it to bulk load will it work ?