Q: I am modeling a new data warehouse. I will be pulling some hierarchy data from a source system that stores multiple hierarchies in one table. I know that I need to break the data out into separate structures for each hierarchy (product line, organization, etc.) The trees are very uneven. One branch might have five levels, but another might only have two. Do I put each hierarchy into one table or do I break each hierarchy into separate tables (one for each level). If I do the later, then how do I handle the shorter branches?

I have worked with clients that strove to get the hierarchies to line up at the same levels. This required input from the business community and sometimes resulted in values that were really placeholders than actual values. This way, the users could run queries and reports and the hierarchies all came out to the same number of levels (even if some of the values were somewhat substitute values).

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