Author Topic: data modelling in data warehouse..surrogate key  (Read 535 times)

Offline Sep2013

  • Community Leader
  • *****
  • Join Date: Nov 2012
  • Posts: 75
  • Forum Citizenship: +0/-1
data modelling in data warehouse..surrogate key
« on: 21 Jun 2017 08:37:51 am »
i am working with claims data
 I have two models one for counting no. of claims and other for relevant payments..both have thier own star schemas conformed using claimant dimension

the issue is that claimang dimension is snapshot over period but payments are transactions..thus if i want to see total paid for claimamt it will not be possible as it will lnly look up the payments made for that particular ss of claimamt.

Please guide me how cab i ensure that independent of which slice of ss i select i am able to see all payment transactions.

see attached example