 Related Questions Answered by swetha on 2005-03-30 12:00:33: OLTP Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction Latest Answer : Difference between OLAP and OLTP Systems Time Scale OLTP: This stores current data OLAP: This stores History data for analysis Indexing OLTP: Optimizes update performance by minimizing the number of indexes OLAP: ... Answered by Hemakumar on 2005-04-12 05:40:50: Cognos BusinessObjects MicroStrategies Actuate Latest Answer : One tool is also missing in the list. i.e. Dundas Chart for .NET OLAP Services ... Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true? 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 ... Read Answers (7) | Asked by : Srinu 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 ... Read Answers (7) | Asked by : ganesh 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 ... Read Answers (5) | Asked by : MF 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 ... Read Answers (5) | Asked by : Aashish Jain Latest Answer : dataware house is a container to store the historical datawhere as dataware hosuning is a process or technique to analyze tha data in the ware house ... Read Answers (2) | Asked by : shivaleela Latest Answer : Star Schema: A single fact table associated to N dimension tables. This schema is denormalised and hence has good performance as this involves a simple join rather than a complex query.Snowflake schema:A star schema in which dimensions are further ... Read Answers (9) | Asked by : swarna Latest Answer : BO is a ROLAP Tool,Cognos is a MLAP Tool and MicroStrategy is a HLAP Tool ... Read Answers (1) | Asked by : prasad
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
