Problem solve Get help with specific problems with your technologies, process and projects.

Relational vs. dimensional data marts

Does a data warehouse design have to be relational vs. a dimensional design in a data mart?
You said "in a data mart". I don't know if you have a data warehouse to go along with that data mart or not.

The last layer in a data warehouse architecture should usually be dimensional because it more greatly facilitates end-user access with its built-in relationships. Some data marts are very specialized, however. Some may not be for true end-user ad-hoc query analysis and therefore the requirements may dictate a different, and sometimes a very particular type, of design. Some support packaged applications.

If you have a single data warehouse/mart only, then you will likely have both relational and dimensional structures in it because it is difficult to jump from many source environments directly to dimensional.

Dig Deeper on Customer data privacy and security

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.