Can we insert and update a target table without using update
strategy transformation?How?

Answer Posted / sreedhar lokaray

Yes you can insert or update a table without using update
strategy. In the Mapping tab of the Session property go to
Target properties and check the attribute value Insert to
insert or check Update as Update to update.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Integration service in Informatica?

705


Explain what are the different versions of informatica?

657


What is the difference between a connected look up and unconnected lookup?

578


What is meant by pre and post session shell command?

628


How to create or import flat file definition in to the warehouse designer?

618






What is dimensional table?

624


What are the differences between source qualifier and joiner transformation?

602


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1660


What is a predefined event?

662


Explain constraint based loading in informatica

661


what is SDLC way of code development?

1562


How can you differentiate between powercenter and power map?

626


What is standalone command task?

713


Differentiate between source qualifier and filter transformation?

1003


What is joiner transformation in informatica?

629