•
DATASOURCE_NUM_IDis part of the unique user key for all tables in the warehouse
schema.
• DATASOURCE_NUM_IDpermits rows to be loaded in
the same warehouse tables from different sources, provided that the column is
given a different value for each source.
The tables in the Oracle
Business Analytics Warehouse schema have DATASOURCE_NUM_ID as part of their
unique user key. While the transactionalapplication normallyensures that a
primary key is unique, it is possible that a primary key is duplicated between
transactional systems.
To avoid problems when
loading this data into the data warehouse, uniqueness is ensured by
includingthe DATASOURCE_NUM_ID as part of the user key. This means that the
rows can be loaded in the same data warehouse tables from different sources if
this column is given a differentvalue for each data source.
DATASOURCE_NUM_IDis
maintained in ODI. Make sure that each source system has a unique value
assigned to it. It is possible to have multiple instances of the same source
system (for example, a U.S.-based and a European-basedOracle
transactionaldatabase both loading into the same data warehouse). The two
different transactionaldatabase systems should be assigned different DATASOURCE_NUM_IDvalues
in ODI.
No comments:
Post a Comment