Interested to Buy Any Domain ? << Click Here >> for more details...
In update strategy t/r we had given dd_insert condition
& in session we gave delete condition .
Then what will happen? mapping will run ?
- 3 Answers
- 8017 Views
- emc2, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek kumar
mapping run .it will take delete condition.
| Is This Answer Correct ? | 9 Yes | 1 No |
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 |
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 |
What happens when a session fails and you click on recover?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
have you developed documents in your project? and what documents we develop in realtime?
can every transfomation reusable?how?
What is aggregator transformation in informatica?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
What is confirmed fact in dataware housing?
how u know when to use a static cache and dynamic cache in lookup transformation.
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Write the prerequisite tasks to achieve the session partition?
Teradata 
