COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: captain karisma on 22 Feb 2009 11:15:48 PM

Title: Data Manager and database keys
Post by: captain karisma on 22 Feb 2009 11:15:48 PM
Hey guys,

I've set up data manager and got my jobstream going and designated my keys in the table delivery options.
However after it successfully runs, i open up SQL2005 and everything is successful but the tables haven't assigned the columns as primary keys.

I want this to be assigned so that in Framework Manager, i can use the first option to match keys.

Does anyone know how i can do this?

Thanks in advance
Title: Re: Data Manager and database keys
Post by: UseCog on 28 Feb 2009 08:51:20 AM
The 'key' option is not to create PKs in the target table and it is to define the update and insert methode. Visit 'Primary Key Settings for Update/Insert'  section in DM document.

However, why cant you create PKs at the backend?

Bst regards,
UG