Stage in Parallel Extender

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
somu_june
Premium Member
Premium Member
Posts: 439
Joined: Wed Sep 14, 2005 9:28 am
Location: 36p,reading road

Stage in Parallel Extender

Post by somu_june »

Hi,

Is there any stage (filestages) in parallel extender like hash file stage in server where we can have any number of inputs or output links. I want to write to a file (same file ) from two transformers. In server job Iam writing to the same hash file from two different transformers. If there is no such type in parallel extender can any one tell me how to achieve my goal in PX.



Thanks,
Somaraju
somaraju
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

In Parallel Extender you have stage called Dataset. Here you can tell how do you want to write to the dataset(Overwite/Append etc.). Check for the Update policy option in it. Unfortunately like server you can have one Stage object with multiple links. You have to select one of those dataset stage for each link.

regards
Regards
Siva

Listening to the Learned

"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
somu_june
Premium Member
Premium Member
Posts: 439
Joined: Wed Sep 14, 2005 9:28 am
Location: 36p,reading road

Post by somu_june »

Hi Rasi,

Thanks for reply . I know that Dataset Stage can have only one input link and Iam asking is there any stage in Px that can have two inputlinks. My requirement is like this I have two transformers with stage variables and I have to output from those two transformers to a file (in server iam using a hash file) . In hash file Iam having reckey and outrec columms from first transformer Iam sending reckey = I and outrec = ....... to hash file and from second transformer iam sending reckey =D and outrec = ......... to the same hash file


Thanks,
somaraju
somaraju
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Post by kwwilliams »

As long as the structure is the same use a funnel. Then output the funnel to your target.
Post Reply