To search a table in SAS DI

[Shakti_Sourav]

Dear Team,

We have so many ETL jobs ( SAS DI ) in our project and  I am not able to examine all the etl jobs to discover the source table that utilizes it

Kindly suggest, how to find the ETL Job that is using a particular source table in a quickest way ?

Thanks 

Shakti Sourav Mohapatra

[AllanBowe · Accepted solution]

This is a native feature in Data Controller for SAS, and available in the community (free) version

Go to View / Lineage / choose library / choose table / choose column (optional) and you get a full impact analysis (jobs and tables in png / svg / csv formats)

https://docs.datacontroller.io/videos/#data-lineage

https://git.datacontroller.io/dc/dc/releases