slowly changing dimension

[farolito20]

is it really necessary have a history table to trace back everything?

[Anonymous]

Sometimes yes, sometimes no. Is it necessary to know that a salesperson belonged to salesteam X in 2010 and now belongs to salesteam Y? It always depends on the audience and business needs I guess

[farolito20]

How I can save the modified data in a table .qvd?

For example, I have an employees_info table and I modified a phone number, but I wanna keep the other number because probably it's ussefull to make an report using old data.

id_employee , name, phone

001, carlos, 4556122

id_employee , name, phone

001, carlos, 9856741

[farolito20]

The difference between that tables is the modified date right?

So.. I need an example of the script