Database Reference
In-Depth Information
Figure 9-20.
Selecting a data source for your data source view
Name Matching
Clicking Next button takes you to one of two dialog windows, depending on whether you have foreign key constraints
in your data warehouse. If you have foreign key constants, the wizard automatically maps logical relationships
between tables based on these constraints. And you will not see the dialog window shown in Figure
9-21
.
If you do not have foreign keys constraints, the wizard tries to create logical relationships between the
selected tables based upon these three options (as listed in Figure
9-21
):
•
Same name as primary key:
A column in one table has the same name as a primary key
in another table. For example, Order.CustomerID relates to the primary key column
Customer.CustomerID.
•
Same name as destination table name:
A column in one table has the same name as the
name of another table. For example, Order.Customer relates to the primary key column
Customer.CustomerID.
•
Destination table name + primary key name:
A column name matches a composite of the
table + primary key column names. For example, Order.CustomerID relates to the primary
key column Customer.ID.
