Q:

In the insurance industry there are a lot of calculations that could be performed on the premium amounts. Most of the calculations have to do with the term premium, effective date and expiration date. If we store the value in the warehouse, it could be easily moved or used in another calculation. How do we determine whether or not a calculated field should be stored in the warehouse versus a mart or in a report?

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