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
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the reusable transformations?
what is diff b/t sorter t/r and agg have the option sorter property...
What is workflow? What are the components of the workflow manager?
What is rank transformation in informatica
Briefly describe lookup transformation?
While migrating the data from one environment to another environment how would you manage the connections?
What is the format of informatica objects in a repository?
What is informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Enlist some properties of sessions.
What do you understand by SOA of Informatica?
What is data transformation manager process?
What is mapplet in informatica?