Forum Discussion
Advocate IIStar Scheme needing unique values
I'm just doing some reading on how to develop good practices for star schema, and have just read that for lookup tables to work they cannot contain non-unique values. I have two data tables with corrosponding categories such as contract name. However many entries will be the same contact name as each contract has a number of instances. It was my previous understanding that this woulod be acceptable for using as a lookup table to link both tables. But reading this has made me unsure as to whether it would work.
Any help on the matter would be greatly appreciated!
Jordan
Sorry for any confusion.
I think I many have just worked out my own problem!
I had many entries in my data tables for coloms such as contract name. There could be up to 50 SO032 for example. But this would not matter as in my lookup tables there would only need to be one instance of the contract name and this would then refer to all in the fact table.
I think my confusion stemmed from reading that lookup tables can only contain unique values. Then looking at my model I saw that these values were repeated. However this does not matter because they are the fact tables. The lookup tables would only need to have one distinct value.Thanks
3 Replies
- parry2k
Super User
JordanJackson sorry your question is not clear, can you share sample data and the output/question
JordanJacksonSorry for any confusion.
I think I many have just worked out my own problem!
I had many entries in my data tables for coloms such as contract name. There could be up to 50 SO032 for example. But this would not matter as in my lookup tables there would only need to be one instance of the contract name and this would then refer to all in the fact table.
I think my confusion stemmed from reading that lookup tables can only contain unique values. Then looking at my model I saw that these values were repeated. However this does not matter because they are the fact tables. The lookup tables would only need to have one distinct value.Thanks
- parry2k
JordanJackson you are on the right track, make distinct value from your fact table in PQ and you are good to go.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
