problem in implementing pivot stage

priyadarshikunal · Post by **priyadarshikunal** » Mon Apr 30, 2007 5:30 am

I have installed datastage few days back.

when I am trying to implement pivot stage, I am getting error message as:

(40822) The source stage does not suppot output links.

but pivot stage must have one stream output link.

I tried to find the cause of error but unable to find it?

Please suggest the cause as well as the way to resolve that!

thanks

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 5:34 am

Tell us ALL the stages in your job design (draw us a picture), and at precisely what point in the job design that this error occurs.

priyadarshikunal · Post by **priyadarshikunal** » Mon Apr 30, 2007 5:52 am

ray.wurlod wrote:Tell us ALL the stages in your job design (draw us a picture), and at precisely what point in the job design that this error occurs. ...

I have a CSV file as input
in which address field is to be broken in different fields

after removing control characters using unix cron
i am reading the input from a flat file and stored it to a oracle table

then form oracle table data is sent to pivot stage

after processing it should go to a oracle table where i am getting that error.

the job looks like

Oracle -> pivot ->oracle

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 3:40 pm

I infer from your note that the error occurs when dragging a link from the Pivot stage to the downstream Oracle Enterprise stage. Is this correct?

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 3:43 pm

I infer from your note that the error occurs when dragging a link from the Pivot stage to the downstream Oracle Enterprise stage. Is this correct?

I was not able to reproduce this problem using version 7.5.1A.

My guess is that you already have an output link from the Pivot stage (look carefully for any red color) which is why Designer will not let you draw a second output link from this stage.

priyadarshikunal · Post by **priyadarshikunal** » Wed May 02, 2007 11:22 pm

yes, I am getting error while dragging the link from pivot to oracle.

priyadarshikunal · Post by **priyadarshikunal** » Thu May 03, 2007 1:27 am

ray.wurlod wrote:I infer from your note that the error occurs when dragging a link from the Pivot stage to the downstream Oracle Enterprise stage. Is this correct?

I was not able to reproduce this problem using ve ...

Since I am not a premium member, I am unable to see the whole reply.

ray.wurlod · Post by **ray.wurlod** » Thu May 03, 2007 3:18 am

For a mere few cents per day you can be a premium member and help to fund the bandwidth costs of DSXchange.

priyadarshikunal · Post by **priyadarshikunal** » Thu May 03, 2007 4:44 am

ray.wurlod wrote:For a mere few cents per day you can be a premium member and help to fund the bandwidth costs of DSXchange.

I will try to get premium membership but help me to solve this problem, my case study can not be completed without implementing that stage.

chulett · Post by **chulett** » Thu May 03, 2007 7:12 am

Answer the question you could see: Is that correct?

ray.wurlod · Post by **ray.wurlod** » Thu May 03, 2007 4:40 pm

My guess is that you already have an output link from the Pivot stage (look carefully for any red color) which is why Designer will not let you draw a second output link from this stage.

priyadarshikunal · Post by **priyadarshikunal** » Mon May 07, 2007 4:01 am

ray.wurlod wrote:My guess is that you already have an output link from the Pivot stage (look carefully for any red color) which is why Designer will not let you draw a second output link from this stage. ...

I can't see any output link.
for that i have compiled the job,
the error is:

there must be an stream output link

problem in implementing pivot stage

problem in implementing pivot stage

Re: problem in implementing pivot stage