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 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. ...
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 ...
the ODS is technically designed to be used as the feeder for the DW and other DM's -- yes. It is to be the source of truth.Read the complete thread at http://asktom.oracle.com/pls/ask/f?p=4950:8:16165205144590546310::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:30801968442845,
Latest Answer: Hi According to Bill Inmon's paradigm an enterprize can have one datware house and datamarts source their information from the datawarehouse. In the dataware house, information is stroed in 3rd Normalization. This Dataware house is build on ODS. You ...
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: ...
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 ...
Answer posted by Shri Dana on 2005-04-06 19:04:05: OLTP cannot store historical information about the organization. It is used for storing the details of daily transactions while a datawarehouse is a huge
Latest Answer: OLTP databases are generally volatile in nature which are not suitable for datawarehouses which we use to store historic data ...
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... ...
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 ...
View page << Previous 7 8 9 10 [11] 12 Next >>
Go Top
