Lineage analysis capabilities

dataservices metadata reports
1

Hi everyone,

I haven’t got access to a BODS installation at the moment and couldn’t find the needed information in the manuals, that’s why I’m asking here:
Does the Impact and Lineage Analysis also provide information about what the mapping between source and column is or does it only contain the information that a source somehow influences a target?
We have dataflows with some pretty fancy mapping rules/conversions which should be extracted. I hoped that this would be readily available in the impact and linage analysis. Is that the case? Or is that information only visible “step-by-step” in the auto-documentation?
I guess it would always be possible to build something on our own querying the repo table but this seems to me such a common use case that I hope this effort is not needed.

Thanks for any information

HerdplattenToni (BOB member since 2011-05-13)

2

Transformations are both present in auto doc and lineage.

However if you want to query on certain transformations a direct query with a like clause will work better.

ALVW_MAPPING is a useful view to start with.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

3

Thanks for the quick answer Johannes, it’s highly appreciated.

HerdplattenToni (BOB member since 2011-05-13)

4

Ah, nice find. I wasn’t aware of that view. :+1:

eganjp :us: (BOB member since 2007-09-12)