snow flake schema – LearnDataModeling.com

DW & ETL

Relational Databases

Database – RDBMS: There are a number of relational databases to store data. A relational database contains normalized data stored in tables. Tables contain records and columns. RDBMS makes it easy to work with individual records. Each row contains a unique instance of data for the categories defined by the columns. RDBMS are used in…

DW & ETL

Data Warehouse Concepts

learndmdwbi9 years ago1 year ago13 mins

What is a Data Warehouse? According to Inmon, famous author for several data warehouse books, “A data warehouse is a subject oriented, integrated, time variant, non volatile collection of data in support of management’s decision making process”. In order to store data, over the years, many application designers in each branch have made their individual decisions…