Following options are available for update strategy : DD

what is the necessity to use update strategy?(except for
updates)

Question Posted / raghav

2 Answers
6432 Views
Emphasis, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is the difference between stop and abort in informatica

1141

What is the sequence generator transformation in informatica?

1261

What is the difference between a connected look up and unconnected lookup?

1000

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1555

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8262

What is the use of transformation?

1052

can anyone explain me about retail domain project in informatica?

7996

How to create the source and target database connections in server manager?

1129

which one is better performance wise joiner or look up

1149

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1142

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1226

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3921

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2442

can u any challenge your project?

2083

Separate from a database, an information bazaar, and an information stockroom?

1126