Interested to Buy Any Domain ? << Click Here >> for more details...
what is the necessity to use update strategy?(except for
updates)
- 2 Answers
- 6431 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 |
Please let me know how to make Data masking in informatica..
What is aggregator transformation in informatica?
explain different types of modeling.
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
explain about informatica server architecture?
What are session parameters ? How do you set them?
What is a look up function? What is default transformation for the look up function?
what is the size of u r source(like file or table)?
why we are using surogate key in real time give me explanation
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
If there are more than one sessions running parallel in a worklet, which will be the last session ?
Teradata 
