Databases Reference
In-Depth Information
6.
Click the Mappings node in the left pane and define the mappings from the
source columns to the destination columns. (This is similar to step 14 in the earli-
er procedure.)
After you define all the mappings, you can test your package and load data into the
Inventory Fact 1997
partition. As soon as the package loads data into the partition, you
can open SQL Management Studio and browse the
Warehouse and Sales
cube. This time
you should see some values for the measures in the
Warehouse
measure group.
FIGURE 22.8
Select a destination partition for the SSIS package.
Mapping Composite Keys
If a dimension attribute key or name is bound to multiple columns in a relational table,
it is a compositekey. For example, in the
Customer
dimension, two columns form the
basis of the
City
attribute's key:
customer.city
and
customer.state_province
.If
you were to decide to use an SSIS package to load data into the
Customer
dimension,
at the mapping stage you would see
City.Key(0)
and
City.Key(1)
in the destination
columns. These destination columns correspond to the
customer.city
and
customer.state_province
input columns, respectively. (Open your Analysis Services
database in BI Dev Studio to see how attributes map to the relational table columns.)
Search WWH ::
Custom Search