Datawarehouse Design Question

[system]

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

The same question posted here:

120×120 10.4 KB

Datawarehouse Design Question Hi GUys I have a data modelling challenge and request some of your thoughts… The source system has two employee tables…one to hold SCD Type 1 information and the other to hold Type 2… The two tables are: Employee (with lots of attributes like Name, address, phone, email, etc that are SCD Type 1) Employee History ( with lots of attributes like cost centre, manager, etc that are subject to change - SCD Type 2) There is a one-many relationship between Employee a…

This topic is locked now.

---

Marek Chladny (BOB member since 2003-11-27)