To join the hierarchy with the detail table, import the detail table into the Designer. Use the Source Analyzer to establish the key relationship. After you import the definition, you can find the detail table information on the Properties tab of the definition in the Mapping Designer. You can then import the detail table definition and create the relationship.

However, when you import a hierarchy and its detail table, you create a logical relationship. The detail table contains the detail information for the leaf nodes. The hierarchy table contains the range of values for the details.

To establish hierarchy relationships: