Hi Olap Gurus,
I have a slowly changing dimension question, pls help..
(using MSSQL 2000 Analysis Service)

Within the operational database I have :
Create Table Salesman (
Salesman_Code char(5) Primary Key,
Supervisor_Code char(5),
Address char(30),
Email char(30),
LastUpdate DateTime
)
Within the datawarehouse I have :
Create Table Salesman_Dim (
Salesman_Id Int Primary Key , // surrogate key
Salesman_Code char(5),
Supervisor_Code char(5),
Created_On datetime
)
I want to handle, e.g : the salesman whose supervisor change in the middle
of the period.
Suppose the Supervisor changes on 15 January, transaction <= 15 January must
use old surogate key, after that must use new surrogate key.
The problem is LastUpdate is changed when ANY column of Salesman table is
changed.

For the good datawarehouse database design, how should I handle this ?
(I avoid to code this on Trigger on operational database)

Thank you for any help,
Krist