DSXchange

I don't think this is possible because there are usually several manual design steps required to convert an EBCDIC file into a delimited data file. There can be multiple outputs for different record types. I think it is possible to convert a file format an hour manually with someone who has access t...

If you are using DataStage 11.5 already then I would look at adding IGC for an Enterprise Glossary with Business Terms and a Data Policy and Rules tree. This would let you define the rules and business terms for a data management standard. It will help if you need to roll out additional information ...

Interesting to note that there are no enhancements to old IGC and lots of enhancements to new IGC including workflow. IBM are slowly weaning off old IGC to the new one. I am not sure where the Business Glossary sits in these plans. Is the Glossary going to be added at some point to new IGC? A few ne...

I am pretty sure that if you got audited by IBM you would be found to be in breach of your license and they would stick you with a sizable bill for back payment of QualityStage licenses at list cost price for every year you had it installed. This could be tens of millions of dollars. You have VMs wh...

You do have to add the pipes to do a proper checksum. Without a separator between fields your checksum could get false positive matches. The main issue is that it adds the pipe onto the end of the string you are performing the checksum on. Most manually coded MD5 functions will only add separators b...

This should be okay. You can just remove all your DataStage projects other than the InformationAnalyzer one so you are not in breach of license and keep using IA. You can use IA thin client to let Informatica developers browse the results. You don't lose anything from the data analysis capabilities....

Does anyone know if Information Analyzer is supported for use against Microsoft Azure SQL Data Warehouse? I am getting an error when I try to run a simple DQ rule and its looks like IA is trying to use query cursors via the ODBC or JDBC connector which is not supported by the database: pxbridge(0),0...

There was a new feature added in IGC 11.7.0.1 Fix Pack 1: While creating custom attributes, you can add restrictions when you do not want a custom attribute to be available for all assets of the selected type. This is functionality I have been waiting for a long time because when you add a lot of cu...

Thanks Ernie. I got a similar response from IBM support - the feature is deprecated and customers should use open IGC instead. I am going to create some Documentation metadata objects to hold URL and descriptions.

You may be unfamiliar with some of the products listed if you are migrating from an earlier version of Information Server. * Information Governance Catalog New: is a new web application introduced in 11.7 that is a new take on IGC - it is less focused on the Glossary (no Category Hierarchy or Policy...

Just noticed that the "Assign External Assets" no longer shows up in 11.7 - the part of an IGC Business Term where you could add URL links. This isn't listed as a deprecated function in the 11.7 release notes and it may wipe out some important links during IGC upgrades. The Administration ...

I assume DataStage is truncating the data before it sends it to Oracle and thus avoiding the error. Do you see any truncate warning messages in the DataStage job log?

I loved Blueprint Director as an easy architecture diagram tool however it was in an Eclipse user interface and Information Server is moving everything to web based interface - as shown by the new web interfaces for Information Analyzer and DataStage. So Blueprint Director was quietly dropped and ha...

The DataStage CDC stage has been discontinued and while it is in the DataStage 11.7 release it will be removed from future DataStage releases. I believe this is due to problems they had with performance and data consistency. The recommendation is that you land the data to file or database first and ...

I don't see much Metadata Workbench any more and to be honest it was a difficult product to get to know with lots of configuration steps to get lineage working. The Information Governance Catalog that replaced it got lineage right in release 11.3 onwards - it shows data lineage across DataStage jobs...