 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 warehouse is Subject oriented,Integrated Non volatile, Time variant collection of data. unlike transactional systems. Its a Denormalized huge database.Used for Querying and Reporting Analytics. ... Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. Latest Answer : Star schema is a simplest form of data warehouse schema., consists of fact tables (possibly one) and referenced by number of dimension tables. The appearance is like (an centralized fact and surrounded by number of dimensions) a star and hence got the ... 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 : Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized into multiple related tables whereas the star schema's ... Latest Answer : Following are the loading strategies to load data in dimensional table.
1. Full data refresh.
Delete the existing data in the table and then update all the data with new
data.
2. Incremental data refresh (By handling the duplicates)
a. Constructive ... Latest Answer : Aggregate table contains the summary of existing warhouse data , it contains data which is group accordingly (month , quartely etc) depending upon the business needs.For example you may contain transaction in fact table for all the customers but sometime ... 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 : A fact table in a data warehouse is one which contains the numeric data, can be further distributed as 'Additive Facts' and 'Non-Additive Facts'.Additive facts can be the sum of salaries.Non-Additive facts can be something ... 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 : Dimension table contains reference data which gives meaning to fact data. You can also view them as parameters across which you want to analyze the fact data. ... Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 1N.F:- The table should caontain Latest Answer : To paraphrase the oath, and help you remember, in 3rd normal form data in the table depends on the key, the whole key, and nothing but the key. ... Answered by Satish on 2005-04-29 08:20:29: The Aggreation or calculated value colums will go to Fac Tablw and details information will go to diamensional table. Latest Answer : Before broken into coloumns is going to the factAfter broken going to dimensions ... Latest Answer : Find where data for this dimension are located. Figure out how to extract this data. Determine how to maintain changes to this dimension (see more on this in the next section). Change fact table and DW population routines. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
