DSXchange

Hi, is there any way of getting the list of tables used as source DRS, lookups and target DRS in the ETL job.

Yes, there are several ways. The most commonly-posted involve querying the DS_JOBOBJECTS table constraining on OLETYPE. Search the forum for details. Chuck Smith has a utility for identifying hashed files that could be adapted.