Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-06-22 : 08:35:31
|
| I have a customer dimension talble ( 50 million rows) , and the customer data keep changing...what is the best way to load this diemension table without losing the integrity of data?I don;t want to load 50 million rows everytime .. and i want to keep the history of changes on customer's record...so a unique key can be represented for a single customer (for example ,even though a customer has changed her last name after got married)do i have to use the slowly changing dimension type 2 for this? can you show me some examples? HOw can i implement this? |
|
|
|
|
|
Load large dimension table