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
- 7868 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 |
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a data modeling?
What is domain and gateway node?
If you want to create indexes after the load process which transformation you choose?
when will we go for unconnected lookup transformation in Informatica?
In real time scenario where can we use mapping parameters and variables?
1 lac of flat fles in source how to load target at a time?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
What is union transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
what is confirmed dimension?
Teradata 
