Answer Posted / 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 |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
hi real timers . iam waiting for ur reply regarding ETL TESTING
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the different lookup cache(s)?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Differentiate between sessions and batches?
What is a repository manager?
How can we remove the duplicates from flat file source?
What is the function of look up transformation?
What is the use of target designer?
What are mapplets? How is it different from a Reusable Transformation?
What is native users?
According to his methodology what all you need before you build a datawarehouse
How to configure mapping in informatica?