Latest Answer: Conformed Dimensions are used to connect two fact tables. ...
(NOT AS A RELATIONAL,MULTI, HYBRID?)
Latest Answer: The FUNCTIONAL difference between these is how they information is stored. In all cases, the users see the data as a cube of dimensions and facts.ROLAP - detailed data is stored in a relational database in 3NF, star, or snowflake form. Queries ...
Latest Answer: STRAGEGY & PROJECT PLANNINGDefinition of scope, goals, objectives & purpose, and expectationsEstablishment of implementation strategyPreliminary identification of project resourcesAssembling of project teamEstimation of project scheduleREQUIREMENTS ...
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 ...
Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.
What are the various attributes in time dimension, If this dimension has to consider only date of birth of a citizen of a country?
Latest Answer: Source qualifier is a transformation which extracts data from the source. Source qualifier acts as SQL query when the source is a relational database and it acts as a data interpreter if the source is a flatfile. ...
Latest Answer: Surrogate key is a primary key for a dimension table. Most important of using it is independent of underlying database i.e Surrogate key is not affected by the changes done in the database. ...
Latest Answer: BO is a ROLAP Tool,Cognos is a MLAP Tool and MicroStrategy is a HLAP Tool ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>

Go Top