Interested to Buy Any Domain ? << Click Here >> for more details...
what is the necessity to use update strategy?(except for
updates)
- 2 Answers
- 6209 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 |
How can you increase the performance in joiner transformation?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
Why is sorter an active transformation?
What is parameter file?
Differentiate between mapping parameter and mapping variable?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is source qualifier transformation?
what is hash table in informatica?
What are the types of metadata that stores in repository?
how to duplicates from expression transformation without using sorter before that
How to delete duplicate records in a flat file source?
Teradata 
