Print Page - Dimension Surrogate Key based on multiple columns

Title: Dimension Surrogate Key based on multiple columns
Post by: gagnonp on 28 May 2009 02:21:06 PM

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?

Title: Re: Dimension Surrogate Key based on multiple columns
Post by: emma on 28 May 2009 03:07:57 PM

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

Title: Re: Dimension Surrogate Key based on multiple columns
Post by: gagnonp on 29 May 2009 08:48:07 AM

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

Title: Re: Dimension Surrogate Key based on multiple columns
Post by: SSNCOG on 05 Jun 2009 12:32:23 AM

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

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: gagnonp on 28 May 2009 02:21:06 PM