CLEANING UP HASHES

avidal18 · Post by **avidal18** » Mon Jun 05, 2006 12:23 pm

HI! WE ALMOST FINISHED A DWH PROJECT AND WE WANT TO CLEAN ALL THE HASH FILES WE CREATE ON THE DEVELOPMENT PHASE AND BEFORE WE MOVE TO PRODUCTION. IS THERE A WAY TO DELETE ALL THE FILES IN AND ACCOUNT OR WE NEED TO DELETE ONE BY ONE (EVEN SOMEONES DONT HAVE THE NAME) ANY IDEA WILL BE APPRECIATED!!!

REGARDS,

AV

DSguru2B · Post by **DSguru2B** » Mon Jun 05, 2006 12:34 pm

Are you shouting at us

Just kidding

A friendly reminder, dont use caps. Our posters consider that as shouting.
As for your question, do a search. This topic has been covered here before.
Click here for a start.

kcbland · Post by **kcbland** » Mon Jun 05, 2006 12:45 pm

Just create a new project, export/import the jobs, and drop the old project

DSguru2B · Post by **DSguru2B** » Mon Jun 05, 2006 12:59 pm

Pretty Smart Ken.

avidal18 · Post by **avidal18** » Mon Jun 05, 2006 2:53 pm

Excellent Ken, Thank you! One more question If I have some hash files identified and we want this in the new project what its the best practice to import to our new project (hash cleaned)... obviuosly we want to conseved it because takes a a long time to porcess this, we dont know may be with a flat file and reload it into the new one?

Any ideas???

Regards...

kcbland · Post by **kcbland** » Mon Jun 05, 2006 3:38 pm

Take this opportunity to switch to using externally pathed hashed files to a specified directory, you won't have this problem anymore. If you have persistent large hashed files, that another issue. You could write a job to transfer the hashed file from the project to a directory using the opportunity to size the persistent hashed file appropriately.