As part of a Master Data Governance project we are looking to trace back all data items to their sources - Is there a way to get a full lineage of all data items within all packages using Cognos (at least to the Warehouse)?
I know you can view a single data item's lineage within the Reporting tool, but I want to be able to get the lineage for all items and doing this manually is not going to be functional.
Any thoughts would be greatly appreciated.
Thanks in advance,
Adam.
Quote from: adam_mc on 07 Jan 2019 08:20:17 AM
As part of a Master Data Governance project we are looking to trace back all data items to their sources - Is there a way to get a full lineage of all data items within all packages using Cognos (at least to the Warehouse)?
I know you can view a single data item's lineage within the Reporting tool, but I want to be able to get the lineage for all items and doing this manually is not going to be functional.
Any thoughts would be greatly appreciated.
Thanks in advance,
Adam.
Hi,
I'm not an expert in IGC (IBM's Governance Catalog) but I seem to recall hearing it can consume Cognos metadata. This would be a quick way of achieving what you require. If you don't have IGC I suspect the manual item-at-a-time way is your only option.
Cheers!
MF.