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

Can you explain: table fact, dimensions, and OLAP?

The following is unclear to me, can you explain: table fact, dimensions, and OLAP? Also, regarding EAI vs. DW as an integration solution -- what are the differences between EAI and DW?
OnLine Analytic Processing tradtionally splits a relational view into several dimensions, such as time, product, region, etc. This allows ad hoc drill down and aggregation to be performed in advance of the user query, although the cost in storage space is generally higher than what is required for a relational solution.

As far as EAI vs. DW, the first is the means and the second is the end. EAI is used to aggregate information for a data warehouse.

Dig Deeper on Topics Archive

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.