0 Replies Latest reply: Sep 16, 2013 9:09 AM by user1052716 RSS

    How to change the 'Default operating mode' of a mapping on the repository and not from the client

    user1052716

      Hi everybody,

      I am using OWB 11.2.0.3 and under the mapping's configuration property, I have the necessity to change the Run time parameter "Default operating mode" to SET_BASED in almost all my mappings.

      Because I have 745 mappings in which the Default operating mode is different from SET_BASED, instead to open 745 times the 'Configure' and update manually the value, is there a way to update safely these values (with an oracle predefined script) directly on the repository ?

      I know that exists a view called CMPSTRINGPROPERTYVALUE_V based on a table called CMPSCOPrpClasses, but changing this table it's very complicated for me because contains only keys and then I don't know in which way is connected with all the other structures....

       

      If somebody knows a method more efficient to do these updates on the repository and not from OWB client I will appreciated it!

      Thanks in advance

       

      Alessandro