fact tables – LearnDataModeling.com

DW & ETL

Relational Databases

learndmdwbi10 years ago2 years ago01 mins

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

learndmdwbi10 years ago2 years 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…