Dimension Surrogate Key based on multiple columns

[gagnonp]

I am using Data Manager 8.1 to build a Dimension. The source data primary key is composed of 3 columns. This primary key uniquely identifies each row. So far so good.

Data Manager does not allow multiple columns to be Business Key - Primary True.

Any idea?

[emma]

  If you used a composite key to define the business ID, you must use a DataStream derivation
to concatenate it.

[gagnonp]

Emma, do I need to store the derivation result in the dimension as well?

[SSNCOG]

Hi,

As you mentioned  that source is having composite key then we should maintain in target(with Surrogate key if required) . composite Primary key/Simple Primary key will be used for updating Type 1 and Type 2 changes to the target table.

Thanks,
SSNCOG