Question Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..? in Technology Q&A

Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Wed, 11 Jul 2012 06:02:29 GMT

Hi,

What is the difference b/w Semantic key in Write optimized DSO & Semantic groups in DTP..?

What is the role of Semantic key in Write optimized DSO in handling the records?

----------

Regards,

Sam

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Wed, 11 Jul 2012 06:10:36 GMT

Semantic Key identifies error in incoming records or Duplicate records.

To Process the error records or duplicate records, Semantic Group is defined in DTP.

To put it in simple words, all data records in a particular data package that is loaded into the data target are grouped by the sematic keys or groups that are defined.

Hope this helps.

Sundeep

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Wed, 11 Jul 2012 10:49:23 GMT

Hi Sam,

Semantic Keys in WDSO eliminate duplicate records while we are loading data from WDSO to standard DSO.( refer:http://scn.sap.com/thread/2124464)

Semantic Groups in DTP defines primary keys for error stack of DTP.Then ensure that corrected recrods get updated into the target.

Hope it helps.

Regards,

Harish.

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Wed, 11 Jul 2012 13:33:49 GMT

Agreed. Would be great if we can get any examples to demonstrate this some where....

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Wed, 11 Jul 2012 17:51:52 GMT

Semantic Keys in Write Optimized DSO :

1. If you are using the Write Optimized DSO for lookups etc - then you will need a semantic key - otherwise the lookups will be full table scans.

Semantic Keys is more for organizing the data in a readable format within the WDSO.

Semantic Keys for DTP -:

When loading data to another target - if you want to group the records in a specific way - for instance if you want to store the maximum value for each customer - then you will have to group the data to find this out when loading the information - this would mean that all the data for that customer should be in the same DTP data package - for this you use a semantic key in the DTP.

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

former_member188080 — Thu, 12 Jul 2012 03:10:35 GMT

In WO DSO data record is identified separately based on semantic keys..so data gets loaded in DSO and stacked separately wrt these leys..

its behaviour almost like a cube in terms of data storage..

semantic groups in DTP u identify will be based on key fields in DSO for eg..

so data packet gets loaded looking at this combination of keys from source system..there is no question of shifting of data,from one data packet to another..

Thanks and regards

Kiran

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Thu, 12 Jul 2012 05:15:37 GMT

Hi Arun,

Would you please elaborate Semantic groups in DTP with an example as I couldn't get the complete understanding..?

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Thu, 12 Jul 2012 06:03:15 GMT

Semantic keys are used mainly to identify the error in incomming records or duplicate records and also semantic keys protect the data quality.

The semantic key determines which records should be detained when processing.

All subsequent data records with same key are written to error stack along with the incorrect data records. These are not updated to data targets,these are update to the error stack.

In order to process error records or duplicate records, you must have to define Semantic group in DTP (data transfer process) that is used to define a key for evaluation.

If you want to use the Write optimized DSO objects in BEx Queries, it is recommended that you define semantic key and that you run a check to ensure that the data is unique.

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Thu, 12 Jul 2012 10:25:36 GMT

Hi Sundeep,

I am now clear about Semantic keys in DSO.

But, I am looking for elaborate explanation about semantic groups in DTP.

Re: Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

Former Member — Thu, 12 Jul 2012 11:26:21 GMT

Read the section Importance of Semantic Groups in the below document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80dd67b9-caa0-2e10-bc95-c644cd119f46?QuickLink=index&overridelayout=true&51887500308655

Hope this helps.

Sundeep