Interested to Buy Any Domain ? << Click Here >> for more details...
what is the necessity to use update strategy?(except for
updates)
- 2 Answers
- 6315 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / raghav
Following options are available for update strategy :
DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.
so u can use update strategy for delete, reject or insert.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
Write the prerequisite tasks to achieve the session partition?
What is the use of an aggregator cache file?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How might one distinguish in the case of mapping is right or not without associating session?
What is union transformation?
What is joiner change?
What are the tasks that can be performed using sq?
What is a joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain the code page compatibility?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the tuning techniques you applied during your last project
what is unit testing?tell me proceedure
