Netezza / PureData – How to add comments on a field

Netezza / PureData Table Documentation Practices The ‘Comment on Column’ provides the same self-documentation capability as ‘Comment On table’, but drives the capability to the column field level.  This provides an opportunity to describe the purpose, business meaning, and/or source of a field to other developers and users.  The comment code is part of the … Continue reading Netezza / PureData – How to add comments on a field

What are the Factor Affecting the Selection of Data Warehouse Naming Convention?

Database Table The primary factors affecting the choices in the creation of Data Warehouse (DW) naming convention policy standards are the type of implementation, pattern of the implementation, and any preexisting conventions. Type of implementation The type of implementation will affect your naming convention choices. Basically, this boils down to, are you working with a … Continue reading What are the Factor Affecting the Selection of Data Warehouse Naming Convention?

PureData – Table Effective Practices

Database Table Here a few tips, which can make a significant difference in the efficiency and effectiveness of developers and users, making information available to them when developing and creating analytic objects.  This information can, also, be very help to data modelers.  While some of these recommendations are not enforced by Netezza/PureData, this fact makes … Continue reading PureData – Table Effective Practices

IBM InfoSphere Business Glossary Anywhere Client Is Gone

IBM InfoSphere Business Glossary Anywhere I thought I would post this, to point out what appears to be a case of incorrect  documentation, with regard to InfoSphere Information Server (IIS) 11.5 and 11.3. According to IBM's own documentation 'InfoSphere Business Glossary, InfoSphere Business Glossary Anywhere, and InfoSphere Metadata Workbench are consolidated into the new product InfoSphere … Continue reading IBM InfoSphere Business Glossary Anywhere Client Is Gone