additional metadata request

Jun 9, 2014 at 10:32 PM
Hi!

Love this tool! it's great - wondering if you would consider enhancing it to help trace a column from source through the components to the target.

I'm trying to find a way to get a look at the metadata to build a view like Informatica's Column Link Path functionality.

http://2.bp.blogspot.com/-FaQ7iBHAF-s/UcLe3J-rJBI/AAAAAAAAIUg/DfG8BE0obgY/s640/PC_SelectLinkPath.png


Select a destination column and execute the function. It traces through all components to identify source lineage back to the source.

So if destination column FIRST_INSTALL_DATE was based on 2 source queries which are merged through the pipeline and then in a derived column component calculated as "ISNULL(column1)?ISNULL(column2)?NULL:column2;Column1 ... I would be able to see that the target column was sourced through a derived-column named "FIRST_INSTALL_DATE_v" which was based on SRC1.column1 and SRC2.column2 where SRC1 is an ole-source and SRC2 is a different ole-source.

something like that?

Cheers,

Fahim.