Click here to get free chapters (PDF) in the mailbox What are slowly changing dimensions (SCD)? SCD is abbreviation of Slowly changing dimensions. SCD applies to cases where the attribute for a record varies over time. There are three different types of SCD. 1) SCD1 : The new record replaces…Read More
Click here to get free chapters (PDF) in the mailbox What are normalization forms? Please visit this article. Describes the foreign key columns in fact table and dimension table? Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of facts tables are primary keys of Dimension…Read More
Let us learn about Data Warehousing Interview Questions and Answers.
Click here to get free chapters (PDF) in the mailbox This series is in response to many of my reader’s continuous request to start Data Warehousing Interview Questions and Answers series. This series is written in the same spirit as previous two series which has received good response. Samples Question…Read More