COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: specialist on 23 May 2011 04:21:04 AM

Title: Data bind errors in Data Manager
Post by: specialist on 23 May 2011 04:21:04 AM
Hello,
We've recently upgraded from Decisionstream 7.2 to Data Manager 8.4.1.

Some of the dimension builds that were loading the data(by truncating in case it exceeds the target column size) using Decisionstream are not working in same fashion in Data Manager. It throws column bind error message.

Is there any setting in DM 8.4.1 to load the data by truncating extra characters.

Regards,
SB
Title: Re: Data bind errors in Data Manager
Post by: MFGF on 23 May 2011 08:18:55 AM
I think you'd need to define datastream derivations for the columns in question to ensure the source values are not too big for the target columns, and to truncate them if so.

Regards,

MF.