Page 1 of 1

usage analysis of hash file

Posted: Wed Feb 08, 2006 8:47 am
by vinodhraj
Hi DS Gurus,

I have hash files outside the repository. How I can do usage analysis ?

Thanks

Vinod

Posted: Wed Feb 08, 2006 9:10 am
by ArndW
The analysis tools require that a file has a local VOC entry. You can use the "SETFILE /path/to/your/file DUMMYFILENAME" and then a "ANALYZE.FILE DUMMYFILENAME" to do this.

Posted: Wed Feb 08, 2006 11:02 pm
by ray.wurlod
I think Vinod means a Usage Analysis such as is done in Manager, rather than an ANALYZE.FILE.
That said, the answer is that you must still SETFILE, and import the file definition. Alternately you can Save the hashed file definition from your job design and import it everywhere else it's needed.
Usage Analysis relies totally on a disciplined approach having been followed to making sure that the linkage between table definitions in the Repository continues to be preserved in job designs - that is, that you don't modify table definitions in job designs except via the import process.
If you've done that properly, then Usage Analysis will work.

Posted: Thu Feb 09, 2006 1:58 am
by ArndW
Ray, your interpretation of the question makes a lot more sense. I've started using usage analysis extensively and love that functionality -- but it does require using the metadata for tables and files otherwise it does fall apart. But when it works it makes development and change tracking so much easier!

Posted: Thu Feb 09, 2006 3:27 am
by ray.wurlod
Welcome aboard! :wink: