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

Сообщений: 43

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.

I didn't find the right solution from the Internet.


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

← Назад