What is fact less fact table? Where you have used it in your project?
What is the difference between datawarehousing and businessintelligence?
Data Warehousing: It is a process that includes the extracting the data (from source systems), cleaning, transforming and delivering them to the Data Warehouse (databases) for the loading purpose.&nbs...
Business Intelligence:BI is a broad cateogry of applications and technologies for gathering, integrating, storing, analysing and providing access to data to help enterprise users make better business ...
What is active data warehousing?
Active Data Warehouse is the DWH that enables the decision makers of the organisation to understand the trends and patterns of the market (by analysing the captured transactional data in the DWH) and thereby helping them to arrive at an INFORMED future decision(s).
Thanks.
Alpesh
Active Data Warehousing (ADW)The technical ability to capture transactions when they change, and integrate them in to the warehouse - along with maintaining batch or scheduled cycle refreshes.
Explain in detail about type 1, type 2(scd), type 3 ?
SCD-1 (Current)Overwriting the old values in the dimension record. SCD-2 (History and Current)Creating an additional dimension record at the time of the change with the new attribute values. ...
SCD means Slowly Changing Dimension. The price of the product, address of the person, name of the city are few examples of SCD.There are three methods to capture SCD.Type 1: Overwriting the old values...
Expresses the minimum and the maximum number of instances of an entity b that can be associated with an instance of an entity a. The minimum and the maximum number of instances can be equal to 0,1, or n.
Cardinality describes a join between 2 tables by stating how many rows of one table will match with rows of another table. It is very important to detect join problems and to create the contexts to co...
Cardinality means "How many instances of an Entity (on one side of the join) are related to the how many instance of another entity (on the other side of the join)"
What is a cube in datawarehousing concept?
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 ...
yes,cube is a logical representation of data.12 steps are required for the creation of cubes.its mainly used for analysis purpose. we can analyse which product can be sold more in which country all these we available in the cube by performing operatoins like roll-up,drill-down,slice and dice
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
We cannot do any measures on it.
Values are generally text in nature.
We maintain a status to track the event.
Ex-Visitors to the office.
List of people for the web click.
A fact which has possibly NO measure but can be seen as count of occurences or events is called factless fact. example: no. of accidents per month on roads.If i elaborate more, no. of accidents i...