Correct Way to Handle Count of Notes that is in a separate table

  
Сообщений: 43
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

3D Medical Video
В начало страницы 
|
Перейти на форум:
Быстрый ответ
Чтобы писать на форуме, зарегистрируйтесь или авторизуйтесь.

← Назад