Can some one share with me my data model perfect ?

[paulyeo11]

Hi All

Last week after i post the below post , i get many response to help me , In order to confirm my data model is perfect , i like to create a new post on this.

it my data model perfect ?

After i remove SOURCE field from below table  :-

AP Aging

AR Aging

ARSummary

I also give the above table unique name for cust_id and company. My my data model as below :-

Now i think my data model is perfect right ?

Paul

[robert_mika]

Perfect is kind of  a big word.

You do not have synthetic keys that for sure ,but I can see that you got TERMS and terms  and IDSE and iDSE fields.

Do they differ?

You can test your model with rwunderlich

Document Analyzer ‌

to see if there could not possible improvement.

[marcus_sommer]

Take a look here: A perfect datamodel?

- Marcus

[paulyeo11]

Hi Marcus

Thank you for your feedback.

The reasons I make my data model W/o sync key , is I realise under my situation , this will not create issue when I load all my actual data into QV.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

[paulyeo11]

Hi Marcus

Thank you for the link.

Paul