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
What is sorter transformation?
Explain informatica architecture - version 8 / 9
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?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain in detail scd type 2 through mapping.
What is dimensional table?
While migrating the data from one environment to another environment how would you manage the connections?
How to call shell scripts from informatica?
What are the different components of powercenter?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is meant by query override?
How can we update a record in the target table without using update strategy?
which one is better performance wise joiner or look up
What is the difference between stop and abort in informatica
What are the modules in Power Center