Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

In update strategy t/r we had given dd_insert condition
& in session we gave delete condition .
Then what will happen? mapping will run ?

Question Posted / minisweet85

Answers were Sorted based on User's Feedback



In update strategy t/r we had given dd_insert condition & in session we gave delete condition ...

Answer / abhishek kumar

mapping run .it will take delete condition.

Is This Answer Correct ?    9 Yes 1 No

In update strategy t/r we had given dd_insert condition & in session we gave delete condition ...

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

In update strategy t/r we had given dd_insert condition & in session we gave delete condition ...

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

Post New Answer

More Informatica Interview Questions

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

which one is better performance wise joiner or look up

0 Answers   Informatica,

What is degenerated dimention table?

7 Answers   Patni,

What is fact table? Explain the different kinds of facts.

0 Answers  

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

Which is costliest transformation? costly means occupying more memory?

3 Answers  

What is informatica?

0 Answers  

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

For more Informatica Interview Questions Click Here
Categories