what is the necessity to use update strategy?(except for
updates)
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
where to store informatica rejected data?
Define mapping and session?
What is the use of source qualifier?
What is the Process to creating lookup transformation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain sessions?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the issues you have faced in your project? How did you overcome those issues?
what is degenerated dimension?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to improve the performance of a session using sorter transformation?
What is a mapplet/worklet in informatica?
What is target load order?
What is workflow? What are the components of workflow manager?
draw informatica architecture 8.6 ?