on 12-03-2007 6:52 AM
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
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 ....................
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
Make all the fields which are keys in the tables as key fields in DSO.
Hope this helps
Regards
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would make all keys from 4 tables as Keyfields and make sure 13000 are loaded to ODS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.