cancel
Showing results for 
Search instead for 
Did you mean: 

ODS key/data fields

Former Member
0 Kudos

Hello,

How should I think when defining the key and data fields in an ODS?

Whic info objects should be used as key or regular data field?

Best regards,

F C

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi F C,

Lets say you want to have an ODS for Employee then you would have the Employee Id as the key field and the Data fields as Department, Salary, Address, etc. Now lets say after 1 load you load again then the Employee record would get overwritten for the same value of Employee Id. Thus there would always be existing 1 record for a key field or a combination of key fields.

hope this helps.

Bye

Dinesh

Former Member
0 Kudos

Ok, so I guess that it would be very inappropriate to use, say for example Profit center as the key since all the data from the init load will be replaced with the data of the delta. In this scenario I will then not be able to get the total postings in the ODS (since the postings from init are gone..)? Is this correct?

Actually I want to load PCA-documents into an ODS on item level. So then I guess the key must consist of the document number and the item number (2 primary keys)? Is this correct?

Best regards,

F C

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi F C,

Imagine you are going to populate a table where the combination of the key fields are like primary keys and the rest are data fields.

Bye

Dinesh

Former Member
0 Kudos

Could you provide an example?

thanks,

f c

former_member188975
Active Contributor
0 Kudos

Hi F C,

Key figures can only be used as data fields. The key fields would comprise of those chars, a unique combination of whose values will determine the records in the ODS.

Hope this helps...