SYMPTOM:
While using Strategy Developer 9.x and 10.x with a Netezza data warehouse, some tables listed on both sides of a Warehouse Catalog pointed to a Netezza data warehouse:
Additionally, the structure of the warehouse tables may appear to update correctly, but when trying to show sample data, and error may be thrown:
Error processing table structure The table 'Table' could not be found, please check the table prefix defined for it.
CAUSE:
This may occur when there are multiple namespaces in the warehouse database, each of them containing tables with the same name but with different structures.
ACTION:
In order to resolve this issue, it is necessary to change the warehouse catalog read settings:
Open the warehouse catalog, and click options.
Within this dialog, click on read settings, and then enable the check box 'Ignore current table name space…' as below.
Click 'OK', then save and close the Warehouse Catalog. When the Warehouse Catalog is reopened, the issue should be resolved.
