What are the options in the target session of update
strategy transsformatioin?

Answer Posted / santhoshi

INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the transformations that are not supported in mapplet?

600


Under what condition selecting sorted input in aggregator may fail the session?

663


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

698


How can we create index after completion of load process?

600


How to generate or load values in to the target table based on a column value using informatica etl tool.

610






What is sorter transformation?

585


What is incremental aggregation?

575


How to go to the older version for a mapping?

604


Can we create a Integration service without a Repository service and vice versa?

725


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

555


How union transformation is used?

593


How to do unit testing in informatica?

722


How to open an older version of an object in the workspace?

618


What is target designer and target load order?

657


What are the different types of olap? Give an example?

564