Interested to Buy Any Domain ? << Click Here >> for more details...
what is the necessity to use update strategy?(except for
updates)
- 2 Answers
- 6328 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 is a filter transformation?
Write the program through which the records can be updated?
What are session parameters ? How do you set them?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
can any one explain me about junk dimension
What is Target Update Override? What is the Use ?
What is a poling?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
how to load dimension table and fact table. plz tell me the steps.
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
Teradata 
