This is probably quite simple ... I want to create a little hash file with some literal values. And I can build these values in the transformer stage, so I have a 2 stage job: xfm => hsh. But the compiler doesn't like it, telling me there is "no primary input stage". Is there a short-cut here or must I build a source file somewhere and then read it in ... ???
I think you can do what you want to do with Stage Variables... Having said that, I usually just build a little text file and read it in to a hash file for stuff like this... That way if the data ever changes, I just change the file and don't have to recompile the job.
I did not think it is possible but it will allow you to have a transform without primary input. You need stage variables. Like x=1 initial value then x=x+1. Next you need a constrait like x<100. Try it. I have seen people do this to create time and day dimensions. Saves coding the whole thing in a batch job. I still prefer batch jobs. Reading and writing to hash files is too easy in BASIC.
