Generating Consistent Data Across Snapshots
The EXTRACT_DATE signifies a weekly snapshot of EMPLOYEE table. I can easily change the name information, but I would like the new changed name information to be consistent over multiple EXTRACT_DATEs. So, can this be done? If so, an example would be greatly appreciated.
Thanks in advance.