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?
What are roles and groups and benefits of using them?
What is aggregate cache in aggregator transformation?
During the running session, output files are created by informatica server. Enlist few of them.
What does “tail –f” command do and what is its use as an Informatica admin.
permutations of mapplet
Explain the different kinds of facts.
What are batches?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the different lookup cache(s)?
how to load rows into fact table in data warehouse
What are the types of schemas we have in data warehouse.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
difference between informatica 8.1.1 and 8.6
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs