Relation between 2 dimensions

View previous topic View next topic Go down

Relation between 2 dimensions

Post  radsampath on Fri Aug 06, 2010 10:30 am

Hi
Not sure whether the one which i posted yesterday was posted or not ...not able to find that.

Before i start i would like to let you know that i searched through all messages and i am not finding what i want

I have 2 dimensions 1.Agent 2.Policy(insurance domain) an agent can own many policies sold by his/her to many customers and will be getting commission whenever premium is paid.Its also possible that a policy can be moved /tranferred from one agent to another agent,now i want to maintain the relationship between the 2 dims so that at any point we would be in a position to what agent is having what policy.I came to know that this can be done with the help factless fact but i want to get some expert opinion so i am not overlooking the details.Also if you can share some sample table structure it would be of great help.

When we have to make an entry in the table.Is it when the Agent changes or Policy changes.Agent is higher grain than Policy

Is this need to be captured at the end of time period such as end of week or end of month .

Please let me know what is the best practice and what are the things should be considered while designing this table structure.Please throw some light on this





radsampath

Posts : 8
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Relation between 2 dimensions

Post  ngalemmo on Mon Aug 23, 2010 3:12 pm

A factless fact table is typical for tracking such things. You probably want to include effective and expiration dates as dimensions (degenerate or otherwise) as well.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum