topic Re: To search a table in SAS DI in SAS Data Management

To search a table in SAS DI

Shakti_Sourav — Mon, 17 Jun 2024 05:59:29 GMT

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 — Mon, 17 Jun 2024 07:57:45 GMT

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