DSXchange

DataStage releases usually have six years of support. Information Server 9 released in 2012 ends support in the middle of this year. Information Server 11.7 which includes DataStage Server Edition should have active support through to 2024. So even if IBM discontinues Server Edition (and I haven't h...

According to one of my IBM contacts - Enterprise Search is currently only available as a Linux container but will be available on Windows and Unix at a later date. There will be an Information Server 11.7 upgrade package also available in Feb for in place upgrades from 11.5.

Enterprise Search is a new component in 11.7 and it only runs on a Red Hat environment using a Docker download from Passport Advantage so the software is all pre-installed. I believe this is because of the open source components it is built on. It is an optional component - it adds a web search port...

Depends on what business process you want to follow out of the clerical review. During the testing phase you will need a block of time to investigate the clerical reviews and then go back and improve your standardisation and matching rules to reduce future clerical reviews. You have a process of adj...

I am on Information Analyzer 11.5 fix pack 2 and I have a recurring problem when I add a new Data Class to IGC. I choose Valid Values as the validation type. I set it to Enabled. I then run profiling in Information Analyzer but the new Data Class is not picked up in the automated classification. It ...

Is this a file generated by Cobol or from IMS? There should be a Cobol Definition File or Copy Book that DataStage can import to load up the required metadata to read the file. This would not just identify the record type, level and position of the header record but would also handle Cobol keywords ...

This can happen if you have a QualityStage license but not a DataStage license (or if you have the IIS for Data Quality bundle as mentioned above). QualityStage only has access to a subset of DataStage stages and CDC is one of those stages you cannot use under a QualityStage license. To activate it ...

If you are using Information Analyzer and you don't like the Workbench user interface you should take a look at IA Thin Client version 11.5 Governance Rollup 7. It is better than IA Workbench in navigation around profiling results. It has a data quality scoring system for datasets and columns. It is...

Take a look at Analytix DS Lightspeed. It can reverse engineer DataStage jobs into mapping specifications and then generate Informatica jobs. You need to verify they support your version of the products. It may save you up to 80% of the development effort. You still have a big testing exercise and d...

I usually estimate 2 to 5 days of install time after planning and architecture has done its job. 2 days gives you time to download, copy, check prereqs and run the install process. If it works first time it is finished in a few hours. If something goes wrong it could take a few days of troubleshooti...

If it's a cloud based DashDB the documentation suggests connecting via a JDBC Connector, just use the DataStage on Cloud instructions as it should work in your environment: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.cloud.doc/topics/t_connecting_ds_cloud_to_da...

This is usually a fruitless exercise since it's a big waste of money without any gain for the business users and sponsors. You might be able to automate part of the migration by using a tool that can reverse engineer and generate ETL jobs like Analytix DS, otherwise you need to manually rebuild all ...

On a recent project we set up every term steward as being a business unit steward group. There were about ten LDAP groups created as steward groups and people could be moved in and out of these groups. In Stewardship Center we customised the workflows so that all business term review and approval ta...

I don't think that the Data Rules Stage or the Exceptions Stage in DataStage can be configured to be dynamic - they cannot make use of column propagation or automation of rules based on the metadata of what is fed in. Both stages need design time import and definition of column metadata. There is a ...

Just posted on my blog about how you can get 33% off the WoW conference fee.