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

[Former Member]

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

[former_member188080]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi Arun,

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Sundeep,

I am now clear about Semantic keys in DSO.

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

[Former Member]

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-c644cd119...

Hope this helps.

Sundeep