Requesting advice on Data Lineage options
Posted: Thu Jul 13, 2017 8:36 am
OK guys, I'm confused but I know some of you can help me.
Management is considering software upgrades that may involve re-writing DataStage jobs somehow. I recently provided them with Oracle's delivered data lineage spreadsheets, and began discussing the possibility of generating data lineage reports from DataStage. I have been asked to provide additional research.
Now, I find that there appear to be 3 places from which we may be able to obtain data lineage information! I already knew DataStage could (under the right circumstances) provide data lineage information, but now it seems that Infosphere Information Server can as well, and the IIS information can produce information including OBIEE reporting?! Additionally it seems that Oracle has likewise got abilities in producing data lineage information!
Can someone make this easy for me? What is the best path for me to help out with some job-rewrite-useful-data-lineage information for management to consider? We have everything in a single DataStage project and data collection is not currently turned on for the project (or any jobs that I can tell).
Please help!
john3
Management is considering software upgrades that may involve re-writing DataStage jobs somehow. I recently provided them with Oracle's delivered data lineage spreadsheets, and began discussing the possibility of generating data lineage reports from DataStage. I have been asked to provide additional research.
Now, I find that there appear to be 3 places from which we may be able to obtain data lineage information! I already knew DataStage could (under the right circumstances) provide data lineage information, but now it seems that Infosphere Information Server can as well, and the IIS information can produce information including OBIEE reporting?! Additionally it seems that Oracle has likewise got abilities in producing data lineage information!
Can someone make this easy for me? What is the best path for me to help out with some job-rewrite-useful-data-lineage information for management to consider? We have everything in a single DataStage project and data collection is not currently turned on for the project (or any jobs that I can tell).
Please help!
john3