Tag: Data Click

Essbase Connector Error – Client Commands are Currently Not Being Accepted

While investigating a recent Infosphere Information Server (IIS), Datastage, Essbase Connect error I found the explanations of the probable causes of the error not to be terribly meaningful.  So, now that I have run our error to ground, I thought it might be nice to jot down a quick note of the potential cause of the ‘Client Commands are Currently Not Being Accepted’ error, which I gleaned from the process. Error Message Id IIS-CONN-ESSBASE-01010 Error Message An error occurred while processing the request on the server. The error information is 1051544 (message on contacting or from application:[<<DateTimeStamp>>]Local////3544/Error(1013204) Client Commands are

Continue reading

DataStage – How to Pass the Invocation ID from one Sequence to another

When you are controlling a chain of sequences in the job stream and taking advantage of reusable (multiple instances) jobs it is useful to be able to pass the Invocation ID from the master controlling sequence and have it passed down and assigned to the job run.  This can easily be done with needing to manual enter the values in each of the sequences, by leveraging the DSJobInvocationId variable.  For this to work: The job must have ‘Allow Multiple Instance’ enabled The Invocation Id must be provided in the Parent sequence must have the Invocation Name entered The receiving child

Continue reading

Oracle – How to get a list of user permission grants

Since the Infosphere, information server, repository, has to be installed manually with the scripts provided in the IBM software, sometimes you run into difficulties. So, here’s a quick script, which I have found useful in the past to identify user permissions for the IAUSER on Oracle database’s to help rundown discrepancies in user permissions. SELECT * FROM ALL_TAB_PRIVS WHERE  GRANTEE = ‘iauser’ If we cannot run against the ALL_TAB_PRIVS view, then we can try the ALL_TAB_PRIVS view: SELECT * FROM USER_TAB_PRIVS WHERE  GRANTEE = ‘iauser’ Related References oracle help Center > Database Reference > ALL_TAB_PRIVS view http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2099.htm

Continue reading

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 data sources Information technology (IT)-to-business mapping Data Integration – Transform and deliver A data integration capability, which provides: Transformation Massive scalability Power for any complexity Total traceability Delivery Data capture at any time Delivery anywhere Big data readiness Data Quality – Cleanse and monitor To

Continue reading

Data Modeling – Fact Table Effective Practices

Here are a few guidelines for modeling and designing fact tables. Fact Table Effective Practices The table naming convention should identify it as a fact table. For example: Suffix Pattern: <<TableName>>_Fact <<TableName>>_F Prefix Pattern: FACT_<TableName>> F_<TableName>> Must contain a temporal dimension surrogate key (e.g. date dimension) Measures should be nullable – this has an impact on aggregate functions (SUM, COUNT, MIN, MAX, and AVG, etc.) Dimension Surrogate keys (srky) should have a foreign key (FK) constraint Do not place the dimension processing in the fact jobs

Continue reading

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 practice doesn’t execute or document their conventions.  So, these standard naming conventions may help when none exist or you need to assemble your own naming conventions. <<SomeIdentifier >> = should be replaced with appropriate information Sequence Object Naming Conventions Entity Convention Master Control Sequence (parent)

Continue reading