Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
most recent surrogate key
Hi John, Thanks a lot for prompt reply. I am attaching the two models. Does that mean the bridge table will have natural keys (crash no. and name no.), claimant surrogate key (claimant key) and payment surrogate key (Payment Key)? If a claimant SS is valid for (say) three periods – 1/2/2015 to...- angelkaur
- Post #3
- Forum: Data Warehousing/Big Data
-
most recent surrogate key
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...- angelkaur
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
