SUMMARY
This technical document covers a know issue with GreenPlum 4.x configuration which prevents the varchar datatypes from being correctly recognized in Warehouse Catalog in a Strategy 10 Secure Enterprise Platform environment. This issue has been fixed in Strategy 10.1 Secure Enterprise Platform.
SYMPTOM
When using GreenPlum 4.x database type in Strategy 10.0 Secure Enterprise Platform, it can be noticed that the Vachar datatype columns are not correctly recognized in the Warehouse Catalog on Strategy Developer.
CAUSE
This is a known issue with the out of the box DTMAPPING.PDS file for the Greenplum 4.x object in Strategy 10 Secure Enterprise Platform.
ACTION
This issue has been fixed in Strategy 10.1 Secure Enterprise Platform. Upgrade to this version to take advantage of the fix.
WORKAROUND
In case an upgrade to Strategy 10.1 Secure Enterprise Platform is not viable, contact Strategy Technical Support for a workaround.
