Dimension members that are not changed in the staging database
remain unchanged in the application database. This makes the process of loading
data from the staging database to the application database, the recommended process
for loading dimension data in all cases as long as the data is available from external
sources including an existing data warehouse. However, the proper integration of
staging database changes to the application database is controlled by the value of the
BizSystemFlag field mentioned in the previous paragraph. The possible values of
BizSystemFlag, and the operation performed by the data integration process for each
of these values, is given in Table 7-2.
By looking at Table 7-2, you can see that any ETL process that populates the dbo.
D_Account table in the staging database for the first time should set the value of
BizSystemFlag to 200, at least for the purpose of the examples in this chapter. After
populating the staging database table, the next step in loading dimension data from
staging database is to click the Load This Dimension from Staging Area link in the
BizSystemFlag Value Data Integration Action Taken
100 Indicates that the record is loaded from the Application database to the Staging database
via synchronization. No action is taken during loading from Staging database.
200 Insert records during loading from Staging database.
300 Update records during loading from Staging database.
400 Delete records during loading from Staging database.
Pages:
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332