Professional Emails include a signature Block

I encountered, what I will admit is a pet peeve today, which is why I’m writing this article.  I needed contact someone whom I correspond with regularly, but I have no reason to call or be called by them.  So, after checking my phone, went to their email thinking this would be a fast and … Continue reading Professional Emails include a signature Block

Information Technology (IT) Requirements Management (REQM) For Development

Information Technology Requirements Management Information technology requirement management (IT mаnаgеmеnt) is thе process whеrеbу all rеѕоurсеѕ rеlаtеd to іnfоrmаtіоn technology аrе mаnаgеd according to a оrgаnіzаtіоn'ѕ рrіоrіtіеѕ аnd nееdѕ. Thіѕ includes tangible rеѕоurсеѕ like nеtwоrkіng hаrdwаrе, соmрutеrѕ аnd реорlе, as wеll as іntаngіblе rеѕоurсеѕ like ѕоftwаrе аnd data. The сеntrаl аіm of IT mаnаgеmеnt is … Continue reading Information Technology (IT) Requirements Management (REQM) For Development

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

InfoSphere Datastage – How to Improve Sequential File Performance Using Parallel Environment Variables

APT_FILE_EXPORT_BUFFER_SIZE and APT_FILE_IMPORT_BUFFER_SIZE in DataStage Administrator While extensive use of sequential files is not best practice, sometimes there is no way around it, due to legacy systems and/or existing processes. However, recently, I have encountered a number of customers who are seeing significant performance issues with sequential file intensive processes. Sometimes it's the job design, … Continue reading InfoSphere Datastage – How to Improve Sequential File Performance Using Parallel Environment Variables

InfoSphere DataStage – How to calculate age in a transformer

Age Occasionally, there is a need to calculate the between two dates for any number of reasons. For example, the age of a person, of an asset, age of an event.  So, having recently had to think about how to do this in a DataStage Transformer, rather in SQL, I thought it might be good … Continue reading InfoSphere DataStage – How to calculate age in a transformer

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?