referencing remote hash files

[SBSA_DW2]

Hi Guys

Normally we would just run the before job subroutine "CLEAR.FILE HASHFILENAME" to clear a hash file in the current project.

We have a scenario where we are reading and writing to the same hash file in the same job (aggregating), but need to clear the file before the job runs. The problem is, the hash file is residing on a different project.

Apart from creating a dummy job to clear the file before the current job runs, is there a way to reference remote hash files? Something like:

Code: Select all

CLEAR.FILE PROJECTNAME.HASHFILENAME

Thanks!

[ray.wurlod]

Just set the Hashed File stage properties to "clear file before writing". It doesn't matter where the hashed file is. If the stage can write to the hashed file, it can clear it. (And it will use CLEAR.FILE technology under the covers.)

[SBSA_DW2]

thanks Ray