In update strategy t/r we had given dd_insert condition
& in session we gave delete condition .
Then what will happen? mapping will run ?
Answer Posted / 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 View All Answers
How to create Target definition for flat files?
In which transformation you cannot drag ports into it?
What is deployment group?
Why update strategy and union transformations are active? Explain with examples.
Explain sessions?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to configure mapping in informatica?
What is the reusable transformation?
What are the prerequisite tasks to achieve the session partition?
Which transformation should we use to normalise the COBOL and relational sources?
What is source qualifier transformation in informatica?
can anyone explain me about retail domain project in informatica?
What do mean by local and global repository?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist the advantages of informatica.