Dataset Tracking on Different Projects

DSDexter · Post by **DSDexter** » Tue Jan 01, 2008 11:40 pm

Hi,

Is there any way of tracking a dataset in all the projects on a Server?

We have a EDW, where in there are lots of projects. So a dataset created in one project is being used as a source in another project. I need to track down exactly which all projects a particular dataset is being used.

ALL THE PROJECTS LIE ON THE SAME SERVER.

Thanks

DSDexter

ray.wurlod · Post by **ray.wurlod** » Wed Jan 02, 2008 1:05 am

DataStage is not equipped to shared Data Sets between projects. Because you've managed to trick it is no reason to expect that your trick would be supported by Usage Analysis or any other DataStage tool.

Probably the best you can do is to export each project and search the export file for the Data Set control file name.

ArndW · Post by **ArndW** » Wed Jan 02, 2008 3:56 am

I think sharing a DataSet across projects is valid; it is pretty much the same (in my mind) as sharing a table or sequential file across projects.
There is no builtin method of discovering which DataSets are used in which jobs; but if you have the actual DataSet name hardcoded in the jobs you can examine the .dsx export file and search for that string. If the DataSets are specified in parameters the job is quite a bit harder, but the DSGetParamInfo() routine will let you examine runtime values, so you could program some code in all projects to get the list of DataSets used.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 02, 2008 4:44 pm

It's a co-ordination nightmare!

ramesh_inform · Post by **ramesh_inform** » Mon Jan 28, 2008 4:26 am

It is difficult to use a dataset across projects..

Teej · Post by **Teej** » Mon Jan 28, 2008 8:00 pm

Datasets are not meant to be a long term storage option.