hash file output link Copy
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Fri May 13, 2005 2:35 am
hash file output link Copy
hi ,i need the output link or copy from the hash file to different transformers
Db2stage------->Hash --------->transformer1 ------->
transformer2
Now i need the copy of the link from the hash to be connected to transformer 2 or the same column defintions,there is only one output tab in the hash file,how to do this ?
This has been done in a diferent job,jus cant figure out how to do this without using a extra transformer.
Thanks
Samuel.
Db2stage------->Hash --------->transformer1 ------->
transformer2
Now i need the copy of the link from the hash to be connected to transformer 2 or the same column defintions,there is only one output tab in the hash file,how to do this ?
This has been done in a diferent job,jus cant figure out how to do this without using a extra transformer.
Thanks
Samuel.
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Hi Samuel,
I really don't thing its possible to get mutiple output links from the HASH file, i.e., Can Get One Stream Output and the others reference outputs Only. But if your planning to do it that way, u can have mutiple output links from the same hash file stage on to a Link Collector and then used the output of it to a Transformer.
If you had been using Parallel Extender what ur trying to achieve could be done using a COPY Stage but you donot have Hash file concept in it.
But could you pls explain as to what your planning to achieve by doing the way you stated.
With Regards
Mahesh
I really don't thing its possible to get mutiple output links from the HASH file, i.e., Can Get One Stream Output and the others reference outputs Only. But if your planning to do it that way, u can have mutiple output links from the same hash file stage on to a Link Collector and then used the output of it to a Transformer.
If you had been using Parallel Extender what ur trying to achieve could be done using a COPY Stage but you donot have Hash file concept in it.
But could you pls explain as to what your planning to achieve by doing the way you stated.
With Regards
Mahesh
-
- Participant
- Posts: 15
- Joined: Fri May 13, 2005 2:35 am
MaheshKumar Sugunaraj wrote:Hi Samuel,
I really don't thing its possible to get mutiple output links from the HASH file, i.e., Can Get One Stream Output and the others reference outputs Only. But if your planning to do it that way, u can have mutiple output links from the same hash file stage on to a Link Collector and then used the output of it to a Transformer.
If you had been using Parallel Extender what ur trying to achieve could be done using a COPY Stage but you donot have Hash file concept in it.
But could you pls explain as to what your planning to achieve by doing the way you stated.
With Regards
Mahesh
Hi Mahesh,
the job which i need to modify is a complex one ,and if i insert a transformer,i will have to change a lot of links,in a different job i saw a hash file with two reference links,if i can use the link in another transformer without changing the orginal job links much.Coud you tell how to do this .
Thanks
Samuel.
-
- Participant
- Posts: 15
- Joined: Fri May 13, 2005 2:35 am
Hi Arnd,ArndW wrote:You can have multiple output streams from a hashed file stage as well as multiple reference streams AND even several input streams, too. Just draw a link in the appropriate direction to/from the hashed file stage.
i tried that ,but that box on the link which appears when the definitions are made does not appear.what shoudl be done both output shoudl have the definitions.
Thanks
Samuel.
Since you can define a single hashed file stage (by this I mean the graphical object in the designer) to have multiple output links with multiple hashed files, each of the output link attributes needs to be defined; so if you have 2 links to the same file you will need to click on the drop-down list in the hashed file stage to select the appropriate output link and then enter the information (file name/path, columns, etc.)
-
- Participant
- Posts: 15
- Joined: Fri May 13, 2005 2:35 am
thanks a lot Arnd,got it right.ArndW wrote:Since you can define a single hashed file stage (by this I mean the graphical object in the designer) to have multiple output links with multiple hashed files, each of the output link attributes needs to be defined; so if you have 2 links to the same file you will need to click on the drop-down list in the hashed file stage to select the appropriate output link and then enter the information (file name/path, columns, etc.)
-
- Participant
- Posts: 15
- Joined: Fri May 13, 2005 2:35 am