 Related Questions 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 ... 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. ... Latest Answer : Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose. ... 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. ... Answered by sudhakar on 2005-05-09 18:32:18: star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy... Latest Answer : star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy... ... Latest Answer : create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feilds in ur table.create or replace procedure ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
