Latest Answer: The level of granularity of a fact table signifies the smallest unit of analysis. ...
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: Datamining is nothing but a science of finding information from databases or datasets. ...
Latest Answer: Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno ...
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 ...
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: The ER Diagrams is the initial process to analaysis a database application, and understands the problems related or causes in future with the choosed database application, in this satge different components are watched and studied by the dba's and a diagramatical ...
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: CUBE is used in DWH for representing multidimensional data logically. Using the cube, it is easy to carry out certain activity e.g. drill down / drill up, slice and dice, etc. which enables the business users to understand the trend of the business. ...
Latest Answer: ODS means Operational Data store. ODS & Staging layer are the two layers between the source and the target datbases in the data warehouse..ODS is used to store the recent data. ...
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: A conformed dimension is a set of data attributes that have been physically
implemented in multiple database tables using the same structure, attributes,
domain values, definitions and concepts in each implementation.
Unlike in operational systems ...
View page << Previous 5 6 7 8 [9] 10 11 12 Next >>
Go Top
