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
- 8142 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 is an unconnected transformation?
What are the main features of Oracle 8i with context to datawarehouse?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
explan ur project architecture?
Explain informatica architecture - version 8 / 9
If we are using an aggregator but forget to mention the group by port .what will be the output??
can we override a native sql query within informatica? Where do we do it?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what is work of PUSH DOWN option
wht target override?wht advantages it has compare to target update?
How are indexes created after completing the load process?
What are multi-group transformations?
Teradata 
