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 … Continue reading Essbase Connector Error – Client Commands are Currently Not Being Accepted
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 … Continue reading DataStage – How to Pass the Invocation ID from one Sequence to another
How to know if your Oracle Client install is 32 Bit or 64 Bit Sometimes you just need to know if your Oracle Client install is 32 bit or 64 bit. But how do you figure that out? Here are two methods you can try. The first method Go to the %ORACLE_HOME%\inventory\ContentsXML folder and … Continue reading How to know if your Oracle Client install is 32 Bit or 64 Bit
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. … Continue reading Oracle – How to get a list of user permission grants
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 … Continue reading What are the Core Capability of Infosphere Information Server?
The Six Suites of Infosphere Information Server InfoSphere Information Server 11 Series is, primarily, made up of 6 suites / packages, which provide a mix of components: InfoSphere Information Governance Catalog BigInsights BigIntegrate BigInsights InfoSphere Information Server for Data Integration InfoSphere Information Server for Data Quality InfoSphere Information Server Enterprise Edition (is inclusive of … Continue reading InfoSphere Information Server Suites
Working with timestamp literals in the Infosphere SFDC Connector soql is much like working date literals. So, here a quick example which may save you some time. SOQL Timestamp String Literals Where Clause Rules Basically, the timestamp pattern is straight forward and like the process for dates, but there are some differences. The basic rules … Continue reading SFDC – Using a timestamp literal in a where clause