Question
Considering business intelligence environments to retain historical data for a very long time, select an answer that is a design prototcol. A table containing operational
Considering business intelligence environments to retain historical data for a very long time, select an answer that is a design prototcol.
A table containing operational data activity that has become historical, is designed with attributes/columns that can be totaled for display on reported outcomes and ways to describe those facts. | ||
Large databases have capability to retain millions of completed transactions imported from the operational databases for business applications, so, an OLAP tools can drill down to find detail to support a summary graphic. | ||
A reasonable limit on number of dimension table to describe the transactions that have been imported is to have only five tables because a star has five points. | ||
A star schema design is highly dependent on having a tool like MS Excel for generating graphical displays of financial data.
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started