Skip to Content
author's profile photo Former Member
Former Member

ODS key/data fields

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 07:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Posted on Feb 02, 2007 at 05:27 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 06:06 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.