what is the necessity to use update strategy?(except for
updates)
- 2 Answers
- 5136 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gazulas
man!! u can flag the record as insert or reject.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What are the join types in joiner transformation?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
Differentiate between source qualifier and filter transformation?
What are the types of groups in Router transformation?
What is the difference between SOURCE and TARGET BASED COMMITS?
How to get EVEN & ODD numbers separately?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
Two different admin users created for repository are ______ and_______
how eliminate the duplicates in flat file with out using sorter ,aggregater
What are multi-group transformations?
How is union transformation utilized?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
Teradata 
