The intermediate attributes should have the same number of Key columns as the reference dimension attribute and the data types of the key columns should also correspond.