× Data Warehousing and Data integration

Dimension tables names for claims datawarehouse

  • Posts: 1
  • Thank you received: 0

Dimension tables names for claims datawarehouse was created by kavithakuttyk

i am working for an insurance company.i have to develope a claim datawarehouse using the insurance data.i am following snoflake schema .how many fact table

and dimension tables can i have.?

following are the dimension tables i have
date dimension(columns are date _id,year ,month,quarter date),
location(columns are location id,name,state,zipcode) ,
earth quake,
flood,
policy,
policy_status,
TransactionType,


fact atbles are
claim
claim transaction

i have to provide three more dimension tables in my project(total 10 dimension tables i required).Please provide three more dimension tables name .
1 month 15 hours ago #20476

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies