|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much Latest Answer : Data Warehousing is Relational Database which is specially designed for analysis processing rather then for querying and transactional processing. ... Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes Latest Answer : Data mart is a sub set of datawarehouse and it deals with individual depatments to fufil and support the management system for quick analysis. ... Answered by Puneet on 2005-05-07 04:21:07: ER - Stands for entitity relationship diagrams. It is the first step in the design of data model which will later lead to a physical database design of possible Latest Answer : Entity Relationship Diagrams are a major data modelling tool and will help organize the data in your project into entities and define the relationships There are three basic elements in ER models: Entities are the "things" about which we seek ... Latest Answer : Dimensional modelling consist of 3 stages1.conceptual Requirementshere business architect should be clear with facts and levels (data for Dimension table)2.Logical requirementshere he has to design dimension table with levels, and c=fact table with facts ... Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large Latest Answer : Any schema with extended dimensions(ie., dimesion with one or more extensions) is known as snowflake schema ... 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 : olap->online analytical processing OLAP is a set of specifications which alows the client applications(reports)in retreiving the data from data ware houseoltp->olnline transactional processingOLTP databases are fully normalized and are designed ... Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created. Latest Answer : Fact table is the one which contains measures of interest at most granular level.These values are numeric.Ex:sales amount would be a measure .Each dimension table has a single-part primary which exactly corresponds to one of the components of multiparty ... Answer posted by Riaz Ahmad on 2005-06-09 14:45:26: A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes. Latest Answer : A dimensional table contains detail values/data which is short and wide(ie; less coloums and more rows) Always based on dimensions analysis is done in Datawarehousing. ... Latest Answer : Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose. ... Answered by Puneet on 2005-05-07 04:24:28: Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high Latest Answer : Data Mining: Smpler way we can define as DWH(Data Warehouse)+ AI(Artificial Intellegence)used in DSS(Decision Supportive System) ... Tags : Data Mining
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
