Page 1 of 1

how to create a dummy hashed file

Posted: Tue Sep 26, 2006 12:43 am
by parvathi
what are stages needed to create a dummy hashed file

Posted: Tue Sep 26, 2006 12:51 am
by loveojha2
What do you mean by that?
You can execute this at the Administrator

Code: Select all

CREATE.FILE Hashed_File_Name DYNAMIC 

Posted: Tue Sep 26, 2006 12:51 am
by ArndW
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.

Posted: Tue Sep 26, 2006 1:05 am
by parvathi
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

Posted: Tue Sep 26, 2006 1:10 am
by ArndW
If it is a dummy file then create a dummy key column as well. A hashed file needs at least one defined key column.

Posted: Tue Sep 26, 2006 9:25 am
by DeepakCorning
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.

Posted: Tue Sep 26, 2006 10:01 am
by kduke
Why not use create table?

Posted: Tue Sep 26, 2006 3:18 pm
by ray.wurlod
Why not use a Hashed File stage or a UV stage with the "create" option selected?