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: 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 ...
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 dimension which can be shared with multiple fact tables such dimensions are know as conformed dimension. ...
Latest Answer: In Integrated schema Design, a dimension which can be shared across multiple fact tables is called Conformed Dimension. ...
Latest Answer: SCD1, SCD2, SCD3 are also called TYPE1, TYPE2, TYPE3 dimensions
Type1: It never maintains history in the target table. It keeps the most recent updated record in the data base.
Type2: It maintains full history in the target. It maintains history by ...
View page << Previous 5 6 7 8 [9] 10 11 12 Next >>
Go Top
