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 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
Standards Standard practices help you and other understand your work. This can be very important when working on large teams, working across team boundaries, or when large complex sets of process and objects may be involved. When you consider the importance of naming convention, when coupled with standard practice, the benefit should be obvious, but … Continue reading Infosphere Datastage – Standard Practice- Sequence Naming Conventions
Netezza / PureData Table Documentation Practices Applying a few table effective practices can: Significantly aide others in understanding the purpose and use of tables and column fieldsProvide more migratable meta data to inform and enable the capabilities of other toolsAnd, from a self-preservation point of view, reduce the number of meetings, emails, and phone required … Continue reading Netezza / PureData – Table Documentation Practices
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
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
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?