Hi All,
#0. Accounts Details (slowly changing dimension)
|
|
|
|
---> #1. Balances (daily snapshot - truncated and loaded daily)
|
|
---> #2. Transactions (history data - appended daily)
|
|
---> #3. Access Control List (list of users who can view any given account - changes frequently)
Only the users who have access to an account as per #3 should be able to see #0,#1 and #2 of any given account.
I was originally thinking about implementing parent-child for this (#0 being parent and 1,2,3 being children). But I read in forums that it is not one of encouraged practice. So, I am looking for alternate suggestions.
If I have to think of separate indexes for each of them, I can nest in #3 into #0 and #1. But cant do the same for #2, as it is historically built data.
Seeking expert opinions and suggestions.
thanks in advance.