Adding a Time Stamp to Records in a Data Warehouse
A convenient way to assure data quality is to flag records in the data warehouse according to the date they were loaded. If the load process does not complete or you notice problems after data is already loaded, a time stamp column makes it easy to identify which records were affected. You can then delete all the records processed during a particular phase, return to the pre-load state and address any problems before attempting to load the data again. You can time stamp the load operation by adding an extra column, such as load_date, to your fact table using the SQL Command stage.
To have the dataflow add a timestamp when populating or updating a data warehouse:
The dataflow now adds the current time to a field in each record, providing a time stamp in the data warehouse that shows when each record was loaded.