Map
An Update Row Source can be either a view or a table.
An Update Row Source can be a view in the Transform database that is used in Source rules that process against the data in the Transform Target Source table. Refer to Add Update Row Sources that are Views for more information.
The benefits of using a view as an Update Row Source are:
- Source rules process against current data from the sdb database
- Processing times are shorter as the data is not imported into an st* table in the Transform staging database
- Rules can only update the Add Row st* table
An Update Row Source can also be a table. A snapshot of the data is copied from the Source database into a Transform staging database.
Rules can be created for this Update Row Source table which convert the data before it is processed by the main Source rule. These pre-processing rules are run prior to the rules run on the Add Row Source (as determined by the Target Source priority in Transform). In other words, after the pre-processing rules have run, the main Source rules run on the converted data in the Update Row Source table. Refer to Add Update Row Sources that are Tables for more information.
The benefits of using a table as an Update Row Source are:
- Data is always copied from the sdb database into a Transform staging database
- Snapshot data prevents deadlocks if other processing is currently using the sdb database
- Processing results can be verified quickly by reviewing the local snapshot table
- Rules can be processed to alter data before updating the Add Row Source
