INTERVIEW QUESTIONS DATA WAREHOUSING INFORMATICA DETAILS

Question: 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.

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

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.
1) Within a session:
When you configure the session,you can instruct the informatica server to either treat all the records in the same way.
2) Within a mapping:
within a mapping we use update strategy transformation to flag the records like insert,update,delete or reject. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question