Skip to Content
avatar image
Former Member

DSO not overwriting primary key.

Hi experts,

I have a small problem. I have loaded both transactional data and master data with into a DSO. Then activated the data, and everything is displayed fine till here. I loaded first master data and everything worked fine, but then when i loaded transaction data to DSO, the primary keys that are the same, do not overwrite.

I would like them to overwrite, so in total to have only 7 Rows not 14 as I currently have. The first 7 Rows are Master data and then the second 7 rows are the transactional data.

Please see the picture below. The column with red is what I am trying to overwrite and that is the primary key.

Could you please help me to solve this problem? Should I use different type of infoprovider for putting togheter the master data and transactional data? I believe the problem is at the setting of DTP for DSO but I cannot get the right solutions.

Thank you in advance,

Regys

dataview.PNG (21.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 02:52 PM

    Yes I tried the above suggestions but still the result is the same.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Regys,

      Even if you have a blank value  for a key field it is going to take that.

      In your case most of the data is blank or with data. Hence the blank and the valid data would be considered as 2 entries.

      For Example if you have 2 flows to the same object, some of the fields populated using one and the rest by others, the overwriting would work only if the key data is the same in both the flow.

      Flow 1 Field 1 (Key) Field 2 (Key) Field 3 (Key) Field4 (Data) Field5 (Data) Field6 (Data) A B C 10 D Blank Flow 2 Field 1 (Key) Field 2 (Key) Field 3 (Key) Field4 (Data) Field5 (Data) Field6 (Data) A B C 20 F if flow 1 happens first and flow 2 happens second this is how the data would be in the DSO Field 1 (Key) Field 2 (Key) Field 3 (Key) Field4 (Data) Field5 (Data) Field6 (Data) A B C 20 D F
  • avatar image
    Former Member
    Oct 29, 2015 at 12:10 PM

    Hi Regys,

    Data will over write the keys which we kept under key fields at dso design level.

    so please check your DSO key fields and change accordingly.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi ,

      At DTP there is no settings to set over write.

      is this new dso and  doing at dev system?

      if yes then re edit your dso key fields and activate it.

      later check transformations and activate whole data flow.

      Thanks

  • avatar image
    Former Member
    Oct 29, 2015 at 05:04 PM

    Hi experts,

    issue is resolved. Thank you.

    Best Regards,

    Regys

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 12:26 PM

    Hi Regys,

    The DSO key data  should definitely overwrite.

    Kindly check whether the format of the data(key fields )are the same in master and transactional data.

    Technically the data would be the same but the format would be different.

    For eg : Check for any left padded 0's.Normally it happens to the material related Data One with 0,s and the other with out 0's.Both will be considered as different record.

    00101 & 101 are different for the system.

    Regards

    Vivek

    Add comment
    10|10000 characters needed characters exceeded