Skip to Content
avatar image
Former Member

finalising the keyfields in the DSO or ODS for datasource based on view

Hi

I created a view on 4-R/3.Tables.

1st.R/3-Table Key Fields :- A, B

2nd.R/3-Table Key Fields : C,D --Major Table

3rd.R/3-Table Key Fields :- E, F

4th .R/3-Table Key Fileds:- G,

Then i created a generic datasource. And loading the data into DSO or ODS.

While creating the DSO or ODS should i consider only C, D as KeyFields or Should i consider all the KeyFields of all 4. R.3-Base Tables. Please let me know

Because im getting 13,000 records in PSA and 2000 records in DSO .

Regards

Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 03, 2007 at 06:58 AM

    I would make all keys from 4 tables as Keyfields and make sure 13000 are loaded to ODS.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 03, 2007 at 07:06 AM

    Hi Ravi,

    Make all the fields which are keys in the tables as key fields in DSO.

    Hope this helps

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 03, 2007 at 08:22 AM

    Hi,

    Make all the fields that will uniquely identify the record as key fields of the ODS.

    Since you can have upto 16 key fields, you have the liberty of keeping all the key fields of the 4 tables as key fields of the ODS, so that no records will get overwritten.

    Assign points if useful

    Regards

    Venkata Devaraj ....................

    Add comment
    10|10000 characters needed characters exceeded