In update strategy t/r we had given dd_insert condition & in session we gav

In update strategy t/r we had given dd_insert condition
& in session we gave delete condition .
Then what will happen? mapping will run ?

Question Posted / minisweet85

3 Answers
8233 Views
emc2, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In update strategy t/r we had given dd_insert condition & in session we gave delete condition ...

Answer / abhishek kumar

mapping run .it will take delete condition.

Is This Answer Correct ?

9 Yes

1 No

In update strategy t/r we had given dd_insert condition & in session we gave delete condition ...

Answer / tarun

Mapping will run, but it will not do anything as the
records passing through the Update Strategy Transformation
are marked for insetion but in target we are not selecting
insert. So, There will be nothing in target success rows..

Is This Answer Correct ?

3 Yes

3 No

In update strategy t/r we had given dd_insert condition & in session we gave delete condition ...

Answer / aswin

its all depending on "treat source rows as" option in session level..if we have "data driven" option selected, the Integration service look for update strategy options (DD_INSERT, DD_UPDATE, DD_REJECT, DD_DELETE)

in the above question if DD_INSERT given in UPD and delete is choosen in target property and "Data driven" option is selected then - integration service will reject the row since all rows marked for insert in the mapping level

Is This Answer Correct ?

0 Yes

0 No

Post New Answer