Discussion Board for collaboration on QlikView Scripting.
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 :-
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 ?
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
to see if there could not possible improvement.
Take a look here: A perfect datamodel?
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.
Thank you for the link.