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
- 7827 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 |
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Explain sessions?
What are the disadvantages of Sequence Generator T/R?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
In which transformation you cannot drag ports into it?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What are the reusable transforamtions?
how do the project develops? pls specify right from the start to end in step by steps.
how to remove staging area
Teradata 
