Thanks for your response krishnamoorthy, i am trying to change the logic itself since there is no use of having the history. So trying to map it in the alignment itself.Since users are not going to see the hostory.
EMPID GEOCODE STARTDATE ENDDATE
101 TER1 01/01/ 2012 01/31/ 2012
102 TER1 03/01/ 2012 03/31/ 2012
101 TER2 04/01/ 2012 04/22/ 2012
I am trying to do in the load script as below (Updating the Latest GEO CODE for all the rows of the user ).Once aligment is changed like this.i can use the interval match to get the other things mapped easliy.
Above code will work as long as the end date for two different set of users are different. i tried the above load script code it is adding the terr2 time to terr1.Ideally the end will be common for many records.So i am trying to change at the Alignment itself.