Blog

DWH is a process of building a data warehouse 1) Requirement gathering It is done by business analysts, Onsite technical lead and client In  this  phase  a…

Slowly Changing Dimensions (SCD’s) SCD is a dimension which captures the changes that occur over a period of time. Type I – Contains only current data. Chan…

Confirmed Dimension: Dimensions  maintaining  relationship  with  more  than  one  fact  table  are  called  as confirmed dimensions Shipment (Fact Table) …

1) Addictive Type: Measurements in a fact table that can be summed up across all dimensions Consider the following retail fact table: Store wise sales Pro…

Tables in DWH Dimensions: Dimensions are attributes about facts. They store textual description about business. Dimensions are denormalized due to one to …

Data Acquisition: In DWH terminology, Extraction, Transformation, Loading (ETL) is called as Data Acquisition It is a process of extracting relevant business …

Datamart The difference  between a datamart and a warehouse is their scope: A data mart only seeks to serve the needs  of a portion of the company, such as the…

Differences between OLTP and DWH Problems in existing systems: Data is scattered around multiple operational systems Inconsistency of the data across mul…

Definition of Data Warehousing Data Warehousing is a relational database which is used to store large volumes of data for analyzing business but not for busine…