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
Define mapplet?
How to create Target definition for flat files?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How can we improve session performance in aggregator transformation?
What does reusable transformation mean?
Explain dynamic target flat file name generation in informatica
What differs when we choose the sorted input for aggregator transformation?
Explain the scenario which compels informatica server to reject files?
expain about the tune parameters?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is informatica metadata and where is it stored?
What is the Process to creating lookup transformation in informatica
What is DR strategy for Informatica project?
How do you set a varible in incremental aggregation
What happens when a session fails and you click on recover?