cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Ravi,

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

Hope this helps

Regards

Karthik

Former Member
0 Kudos

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