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?
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access