how to get the latest record from dimension table?
Posted: Mon Sep 04, 2006 11:07 pm
Hi all,
I have a scenario which goes like this.
i have a dimension table named 'customer' with columns customer id,customer name and address.
If a particular customer say A,keeps changing his address,how do i bring in those changes in my customer table.
Conditions are that all the previous addresses should also be preserved,eff date or time stamp shd not be used.And also when the end-user enquires about the customer A,he shd get the latest details about him.
Can anyone clarify me?
I have a scenario which goes like this.
i have a dimension table named 'customer' with columns customer id,customer name and address.
If a particular customer say A,keeps changing his address,how do i bring in those changes in my customer table.
Conditions are that all the previous addresses should also be preserved,eff date or time stamp shd not be used.And also when the end-user enquires about the customer A,he shd get the latest details about him.
Can anyone clarify me?