Infosphere Information Server (IIS) – Where you can view DataStage and QualityStage Logs?

During the course of the week, the discussion happened regarding the different places where a person might read the DataStage and QualityStage logs in InfoSphere. I hadn’t really thought about it, but here are a few places that come to mind: IBM InfoSphere DataStage and QualityStage Operations Console IBM InfoSphere DataStage and QualityStage Director client IBM InfoSphere … More Infosphere Information Server (IIS) – Where you can view DataStage and QualityStage Logs?

What Are The DataStage / QualityStage Join Stages?

While chasing an error to which only applied to join type stages, I thought it might be nice to identify what the InfoSphere Information Server DataStage / QualityStage are.  There are three of them, as you can see from the picture above, which are the: Join Stage, Lookup Stage, And, Merge Stage. All three stages that … More What Are The DataStage / QualityStage Join Stages?

What are the Core Capability of Infosphere Information Server?

Three Core Capabilities of Information Server InfoSphere Information Server (IIS) has three core capabilities: Information Governance Data Integration Data Quality What the Core Capabilities Provide The three-core capability translate in to the high-level business processes: Information Governance – Understand and collaborate Provides a centrally managed repository and approach, which provides: Information blueprints Relationship discovery across … More What are the Core Capability of Infosphere Information Server?

Data Modeling – Dimension Table Effective Practices

I’ve had these notes laying around for a while, so, I thought I consolidate them here.   So, here are few guidelines to ensure the quality of your dimension table structures. Dimension Table Effective Practices The table naming convention should identify it as a dimension table. For example: Suffix Pattern: <<TableName>>_Dim <<TableName>>_D Prefix Pattern: Dim_<TableName>> … More Data Modeling – Dimension Table Effective Practices

Infosphere Datastage – Standard Practice- Sequence Naming Conventions

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 often … More Infosphere Datastage – Standard Practice- Sequence Naming Conventions

Infosphere Information Server (IIS) – Metadata Repository Databases

This is a snippet of very useful information, which is buried in the IBM documentation. So, I thought I would bring it up a level for those of you who may be making decisions regarding Information server installations (IIS).  The table below provides an excerpt of the IBM IIS repository databases placement and guidance.  Please, … More Infosphere Information Server (IIS) – Metadata Repository Databases