DataStage – Timestamp from Datetime

Timestamp from date is one of those data type conversions, which I occasionally have to do in DataStage but can never seem to remember. So, I thought I would write this quick post to document the data type conversion code, which is easy, once I finally remember how to do it again.  The TimestampFromDateTime Function … Continue reading DataStage – Timestamp from Datetime

Infosphere Knowledge Resources

Infosphere Knowledge Resources IBM Knowledge Center The IBM Knowledge Center is the IBM product documentation Site designed to help you plan, install, configure, use, tune, monitor, troubleshoot, and maintain the product. URL:  https://www.ibm.com/support/knowledgecenter/ IBM InfoSphere Information Server Version 11.7.0 documentation The IBM InfoSphere Information Server Version 11.7.0 documentation provides IIS specific documentation about how to … Continue reading Infosphere Knowledge Resources

DataStage – Timestamp from date

This is one of those data type conversions which I occasionally have to do in DataStage, but can never seem to remember. So, I thought I would write this quick post to document  the data type conversion code, which is really easy, once I finally remember how to do it again.  The TimestampFromDateTime  Function DataStage … Continue reading DataStage – Timestamp from date

How the IBM Common SQL Engine (CSE) Improves DB2

Today, newfound efficiencies and innovation are key to any business success – small, medium or large. In the rapidly evolving field of data analytics, innovative approaches to handling data are particularly important since data is the most valuable resource any business can have. IBM common SQL Engine is delivering application and query compatibility that is … Continue reading How the IBM Common SQL Engine (CSE) Improves DB2

An Overview of DB2 Federation

Data analytics has changed where data is no longer manageable in relational databases only. Data is flowing from various sources which are not of the same format. This means it is not possible to store all data in the same repository. Some are best suited for storing in relational databases, others for Apache Hadoop while … Continue reading An Overview of DB2 Federation

DataStage – Netezza Connector Action Column

Over the years have occasionally use the action column feature, however, the last month or so I have found myself using it quite a lot. This is especially true in relation to the tea set and not just in relation to the change capture stage. The first thing you need to know is, if you … Continue reading DataStage – Netezza Connector Action Column

Big Data vs. Virtualization

Globally, organizations are facing challenges emanating from data issues, including data consolidation, value, heterogeneity, and quality. At the same time, they have to deal with the aspect of Big Data. In other words, consolidating, organizing, and realizing the value of data in an organization has been a challenge over the years. To overcome these challenges, … Continue reading Big Data vs. Virtualization