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

Data Modeling – Database Table Field Ordering Effective Practices

Database Table Field ordering can help the performance on inserts and updates and, also, keeps developer and users from having to search entire table structure to be sure they have all the keys, etc. Table Field Ordering Distribution Field Or Fields, if no distribution field is set the first field will be used by default.Primary … Continue reading Data Modeling – Database Table Field Ordering Effective Practices

Infosphere Data Architect Install Error CRIMC1029E or CRIMC1085E

The CRIMC1029E / CRIMC1085E errors may be caused by running the incorrect Infosphere Data Architect installer.  If you run the admin installer (launchpad.exe) on 64bit windows with insufficient privileges, the process will throw a CRIMC1029E / CRIMC1085E error. What the Error Looks Like Installation failed.CRIMC1029E: Adding plug-in com.ibm.etools.cobol.win32_7.0.921.v20140409_0421 to repository E:\Program Files\IBM\SDPShared failed.CRIMC1085E: Resumable download … Continue reading Infosphere Data Architect Install Error CRIMC1029E or CRIMC1085E