Posted by shawnturner on Jan 8, 2018 13:36:27 GMT
Hi,
We have a fact table that we are basing on customers. Each customer can have multiple notes. The notes are annotated in a separate table that is in a many to one relationship based on the customer id.
We want to get the # of notes for each customer. What would be the best way to handle this? Do I need to make a "NotesCount" column in the CustomerFacts table and update that every time the process runs or is there a better way to handle it?
Please help.
Thanks!
I didn't find the right solution from the Internet.
References:https://social.technet.microsoft.com/Forums/en-US/135f8044-df10-4afb-adf7-6b07ac6422cd/correct-way-to-handle-count-of-notes-that-is-in-a-separate-table?forum=sqlintegrationservices
video explainer
We have a fact table that we are basing on customers. Each customer can have multiple notes. The notes are annotated in a separate table that is in a many to one relationship based on the customer id.
We want to get the # of notes for each customer. What would be the best way to handle this? Do I need to make a "NotesCount" column in the CustomerFacts table and update that every time the process runs or is there a better way to handle it?
Please help.
Thanks!
I didn't find the right solution from the Internet.
References:https://social.technet.microsoft.com/Forums/en-US/135f8044-df10-4afb-adf7-6b07ac6422cd/correct-way-to-handle-count-of-notes-that-is-in-a-separate-table?forum=sqlintegrationservices
video explainer