Latest Answer: Generally, data mining (sometimes called data or knowledge discovery) is the process of analyzing data from different perspectives and summarizing it into useful information - information that can be used to increase revenue, cuts costs, or both. Data ...
Latest Answer: ViewsA view takes the output of a query and makes it appear like a virtual table. You can use a view in most places where a table can be used.All operations performed on a view will affect data in the base table and so are subject to the integrity constraints ...
Latest Answer: RalfKimball: he follows bottum-up approach i.e., first create individual Data Marts from the existing sources and then create Data Warehouse.BillImmon: he follows top-down approach i.e., first create Data Warehouse from the existing ...
Latest Answer: Junk Dimension also called as garbage dimension. A garbage dimension is a dimension that consists of low-cardinality columns such as codes, indicators, status,and flags. The garbage dimension is also referred to as a junk dimension. Attributes in a garbage ...
What is the definition of normalized and denormalized view and what are the differences between them
Latest Answer: The Fact table is central table in Star schema, Fact table is kept Normalized because its very bigger and so we should avoid redundant data in it. Thats why we make different dimensions there by making normalized star schema model which helps in query ...
Latest Answer: E-R Modeling is a model for OLTP, optimized for Operational database, namely insert, update, delete data and stressing on data relational integrity.Dimensional Modeling is a model for OLAP, optimized for retrieving data because it's uncommon to update ...
Latest Answer: A fact,which can be used across multiple datamarts is called as conformed fact. ...
Latest Answer: There are four methods in which one can build a datawarehouse.1. Top-Down (Emphasizes the DW. )2. Bottom-Up (Emphasizes data marts.)3. Hybrid (Emphasizes DW and data marts; blends “top-down” and “bottom-up” methods.)4. Federated (Emphasizes the need to ...
Latest Answer: Bus Schema : Let we consider/explain these in x,y axis Dimension Table : A,B,C,D,E,F ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
