how to create a dummy hashed file

parvathi · Post by **parvathi** » Tue Sep 26, 2006 12:43 am

what are stages needed to create a dummy hashed file

loveojha2 · Post by **loveojha2** » Tue Sep 26, 2006 12:51 am

What do you mean by that?
You can execute this at the Administrator

CREATE.FILE Hashed_File_Name DYNAMIC

ArndW · Post by **ArndW** » Tue Sep 26, 2006 12:51 am

All you need to create a hashed file is an output hashed file stage. This applies to any sort of hashed file, be it a "normal" one or a "dummy" one.

parvathi · Post by **parvathi** » Tue Sep 26, 2006 1:05 am

i want to create job in the designer such that when i run the job a dummy
hashed file should be ceated

can i do like this..
transformer------>hashed file
i don't want any column names, just pathand the file name..

i have a doubt what should be spcified as input column in the transformer stage

when i run without specifying anything i get compilation error saying no input column in the transformer

ArndW · Post by **ArndW** » Tue Sep 26, 2006 1:10 am

If it is a dummy file then create a dummy key column as well. A hashed file needs at least one defined key column.

DeepakCorning · Post by **DeepakCorning** » Tue Sep 26, 2006 9:25 am

1. Create a dummy Key column in the file.
2. I think you will need to some constraint depending on @OUTROWNUM or @INROWNUM or a simple counter so that the job runs only for 0 rows and creates the file with no data in it.

As it is a dummy file it does not matter whther what columns it has.

kduke · Post by **kduke** » Tue Sep 26, 2006 10:01 am

Why not use create table?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 26, 2006 3:18 pm

Why not use a Hashed File stage or a UV stage with the "create" option selected?