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 is sorter transformation?

578


Explain informatica architecture - version 8 / 9

665


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5567


Can we change Dynamic to Static or Persistent cache? If so what happens?

1724


Explain in detail scd type 2 through mapping.

609






What is dimensional table?

617


While migrating the data from one environment to another environment how would you manage the connections?

623


How to call shell scripts from informatica?

570


What are the different components of powercenter?

578


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1647


What is meant by query override?

631


How can we update a record in the target table without using update strategy?

653


which one is better performance wise joiner or look up

620


What is the difference between stop and abort in informatica

656


What are the modules in Power Center

1227