on 02-02-2007 5:25 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.