In update strategy t/r we had given dd_insert condition
& in session we gave delete condition .
Then what will happen? mapping will run ?
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 |
how to get flatfile containg 10 records half records one target another half another target
have u done any performance tuning? how u ll do?
i have two source data there is no pk,fk how to join the two sources
What is data caches/ index caches?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
How we can create indexes after completing the loan process?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
What is a command that used to run a batch?
What is meta data and system catalog?
What is the difference between Bulk Load and Normal Load