Print Page - How to combine two Natural Keys in one

Title: How to combine two Natural Keys in one
Post by: Enrique on 25 Oct 2016 07:09:29 AM

Hi guys!!

I have been asked to select two Natural Keys in one dimension from a MDR,

and because I know is only possible to select one I would like to ask if there´s a possibility of combine two in one.

The table´s name is "Oraganisation", the columns are: "org_id", "is_current", "valid_from", "replaced_on", "name", "country"

The Natural keys should be the combination of "name" and "country".

It´s that possible ??

Thanks in Advance , Enrique

Title: Re: How to combine two Natural Keys in one
Post by: bdbits on 27 Oct 2016 11:51:05 AM

MDR meaning DMR?

I normally define surrogate keys in a data warehouse. It makes a lot of things a lot easier.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Enrique on 25 Oct 2016 07:09:29 AM