By default, the Integration Service generates values for one foreign key in a view. If a view has more than one foreign key, the other foreign keys have null values. You can choose to generate key values for all foreign keys in a view. Select the All Hierarchy Foreign Keys option.

The following figure shows the Pedigree_View with two foreign keys, FK_Species and FK_Animal:

If you select the All Hierarchy Foreign Keys option for the Pedigree_View, the Integration Service generates key values for FK_Species and FK_Animal.

The following figure shows sample data for the Pedigree_View with the All Hierarchy Foreign Keys option:

If you clear the All Hierarchy Foreign Keys option, the Integration Service generates key values for one foreign key column. In this example, the Integration Service generates values for FK_Species because Species_View is the closest parent of Pedigree_View in the XML hierarchy. The FK_Animal foreign key has null values.

The following figure shows sample data for the Pedigree_View if you clear the All Hierarchy Foreign Key option:

The Integration Service generates foreign keys to the closest parent.