Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 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.