FDI Data Lineage Subject Area

Yagnesh_Analytics

Introduce a Fusion Data Intelligence data lineage subject area that not only identifies where customisations come from - such as from an supplementary data augmentation, a custom ODI ETL job, or a view-based extension - but also shows the exact column-level details within the subject area to include the semantic logical layer, physical table and even the SME step. This would let developers clearly trace what's custom versus out-of-the-box and understand the source—just like the Excel data lineage Oracle provide for Out of the box but integrated in one seamless view. This would make it much easier to manage and differentiate your data sources.

One step further could be ETL ODI (SNP tables) repository integration / configuration to understand which mapping or package is driving the load to the target table and column.