Explain Use Of Update Strategy Transformation?

1.	Explain Use Of Update Strategy Transformation?
Answer» To flag SOURCE records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading. This is the important TRANSFORMATION,is used to maintain the history data or just most recent changes into the target table. We can set or flag the records by using these two levels. Within a SESSION : When you configure the session,you can instruct the informatica server to EITHER treat all the records in the same way. Within a mapping : within a mapping we use update strategy transformation to flag the records like insert,update,delete or reject. To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading. This is the important transformation,is used to maintain the history data or just most recent changes into the target table. We can set or flag the records by using these two levels.

Answer»

To flag SOURCE records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading.

This is the important TRANSFORMATION,is used to maintain the history data or just most recent changes into the target table.

We can set or flag the records by using these two levels.

Within a SESSION :
When you configure the session,you can instruct the informatica server to EITHER treat all the records in the same way.
Within a mapping :
within a mapping we use update strategy transformation to flag the records like insert,update,delete or reject.

To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading.

This is the important transformation,is used to maintain the history data or just most recent changes into the target table.

We can set or flag the records by using these two levels.

Discussion