Hi,
Would request if somebody can help me with this:
I have a source table coming from a FoxPro system like the one below:
| ID | Name | Region |
|---|
| 001 | ABC | New York |
| 002 | DEF | Miami |
| 003 | GHI | London |
Now the Value of 'Region' is changed randomly without any information - this affects my application since I've applied Section Access based on values of 'Region'. e.g. if a user is given access to data related to 'London' and the 'London' value is replaced with 'New London' - that user would not find any data.
I'm required to find a solution that "maintains historical data & records any changes made in the Region field. Also if it sends out alerts/emails that would be great.
Note:
1. There is no modification time or date available in the table/source.
2. This table is scheduled for reload daily.
Would really appreciate any help on this.
Thanks
Harry
