Querying DS Metadata

santosh · Post by **santosh** » Fri Dec 04, 2009 6:40 am

I have to scan number of DWH datastage jobs where perticular table is used. There are complex user defined sqls as source extraction with lots of joins where this table may have been used. Is there a way to query datastage metadata to narrow the jobs list.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 04, 2009 6:50 am

Yes.

Do you have Metadata Workbench in your mix of products? (Probably not because you're on version 8.0.)

There are myriad examples posted on DSXchange of getting design information out of the DataStage repository. Why not Search for them?

santosh · Post by **santosh** » Mon Dec 07, 2009 6:33 am

All my search resulted in DS 7.5 related repository query. I understand that DS 8.0 repository is installed on SQL Server in our case. Is there any way to query these tables or can you point me to some responses in dsxchange

chulett · Post by **chulett** » Mon Dec 07, 2009 8:01 am

Those tables are well and truly obfuscated. Search here for DS_JOBOBJECTS for some queries that may help. Worst case, you could export the project source and use a text editor to find what you need.