Hi All,
I am creating DTS for my OLAP cube and want to know how u guys do updates to
the existing dimensions and fact tables.
In my case , I am using a running number as the id for all dimension tables
so deleting and inserting new row is not possible. But I have to check and
update dimension properties (say contact no in case of customer dimension),
there may b very few or almost no changes but I have to check for it.
Just wondering how u people do it.
and what about the facts .... if ne of the amount is appended or changed ?

plz guide me on this .

thanks in advance.
kshitij.