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
- 7838 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 |
difference between shortcut and reusable transformation?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
In how many ways we can create ports?
Write the advantages of partitioning a session?
What are the reusable transforamtions?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Clarify the utilization of aggregator cache record?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Teradata 
