Q:

I have been given a task to develop a data warehouse/star schema for a leasing/mortgage business. Most of the star schemas I have seen are for sales applications. Can anyone help me find links or contact information for the correct star design for a leasing business?

A:

Clay Rehm’s Answer: Even though I do not have experience in the leasing business, I could tell you with very high confidence the entities/tables that you will find in each and every business. This includes Customer (if you don’t have customers, how are you making money?), Product or Service (there must be a product or service you are providing), Employee (there are people that work there), Revenue, etc. You would have fact tables that track your leasing transactions, preferably at a very detailed level. At a minimum, your dimensions would include Customer, Product/Service, Date/Time and Employee.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access