 Related Questions Answered by on 2005-03-23 01:45:54: bitmap index Latest Answer : Hash Index - If we know that the hashing will result in uniform distribution and doesn't create hotspots (spikes-chaining).Bitmap Index -
If the degree of cardinality is high for the attribute, means that there are more unique number of values for ... Latest Answer : Raid 0 - Make several physical hard drives look like one hard drive. No redundancy but very fast. May use for temporary spaces where loss of the files will not result in loss of committed data. Raid 1- Mirroring. Each hard drive in the ... Information Packages(IP) are advanced by some author as a way of building dimensional models - e.g. star schemas. Explain what IPs are and Give an example of it\'s use in building a dimensional model. View Question | Asked by : Rokeya Begum Latest Answer : Degenerated Dimension is achieved through a gradual modeling approach
following Dimensional Modeling standards. Let's take example of a Star Schema
representing Sales Invoices. The FACT would have the "Invoiced Amount" as
primary measure. ... Read Answers (8) | Asked by : sharat Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions. Latest Answer : The ability to move between different combinations of dimensions when viewing data with an OLAP browser/Report Browser.Multidimensional analysis tools organize the data in two primary ways: in multiple dimensions and in hierarchies.Slicing and dicing ... Read Answers (2) | Asked by : Sheen Latest Answer : A snowflake schema is a way to handle problems that do not fit within the star schema. It consists of outrigger tables which relate to dimensions rather than to the fact table.The amount of space taken up by dimensions is so small compared to the ... Read Answers (4) | Asked by : sainath Latest Answer : It is designed to support Operational Monitoring. It is subject oriented,integrated database which holds the current,detailed data.data here is volatile ... Read Answers (3) | Asked by : chetan Bill Inmon vs Ralph Kimball In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's Latest Answer : Bill inmon's approach:--------------------------- Approach is "TOP DOWN approach". ;means Emphasize the data warehouse. Starts with designing an enterprise model for datawarehouse. Multi tier architecture - comprise ... Read Answers (2) | Asked by : Pranay
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
