Hashed File record Clearance
Posted: Thu Dec 20, 2007 1:16 am
Hi All,
I have a problem in hashed File.I have an hashed file which has 3 input links.All of them write into the same hashed file..Eg;PartitionHash.
Input1.SaleDay Partition Information.(PYYYYMMDD)
Input2.SaleWeek Partition Information(PYYYYMMDD)
Input3.SaleMonth Partition Information.(PYYYYMM)
The above 3 inputs use thesame hashed file PartitionHash. For each input i checked the Deletefile before create option.All of them pointing to the same File.
So when a job is run a second time it still writes out the records from the first run. I added a step earlier in the job to clear the hashes.
by passing @NULL to the columns of HashedFile before writing the records..and removed the option DeleteFile..No luck.
So how can we handle this situation in DS? Please advise.
Satheesh.
I have a problem in hashed File.I have an hashed file which has 3 input links.All of them write into the same hashed file..Eg;PartitionHash.
Input1.SaleDay Partition Information.(PYYYYMMDD)
Input2.SaleWeek Partition Information(PYYYYMMDD)
Input3.SaleMonth Partition Information.(PYYYYMM)
The above 3 inputs use thesame hashed file PartitionHash. For each input i checked the Deletefile before create option.All of them pointing to the same File.
So when a job is run a second time it still writes out the records from the first run. I added a step earlier in the job to clear the hashes.
by passing @NULL to the columns of HashedFile before writing the records..and removed the option DeleteFile..No luck.
So how can we handle this situation in DS? Please advise.
Satheesh.