Surrogate Key

[Stevennn]

Hi,

How can I set up surrogate key with using Fact Build.

I dont have any dimension builds or lookups.

Thank-you very much!!!!

 

[footyref]

I do not believe you should create a surrogate key for the fact tables.

Scott Gaffney
Information Technology Consultant
Ohio Department of Job and Family Services
Management Information Systems

 

[mfgf]

Hi,

If you are using Data Manager, you have a new option called Record Identity on the Table Properties tab of your relational table delivery. This will effectively add an integer surrogate key to your fact table if you check it. This did not exist in DecisionStream, though.

Regards,

MF.