Page 1 of 1
problem in implementing pivot stage
Posted: Mon Apr 30, 2007 5:30 am
by priyadarshikunal
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
Posted: Mon Apr 30, 2007 5:34 am
by ray.wurlod
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.
Posted: Mon Apr 30, 2007 5:52 am
by priyadarshikunal
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
Posted: Mon Apr 30, 2007 3:40 pm
by ray.wurlod
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?
Posted: Mon Apr 30, 2007 3:43 pm
by ray.wurlod
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.
Re: problem in implementing pivot stage
Posted: Wed May 02, 2007 11:22 pm
by priyadarshikunal
yes, I am getting error while dragging the link from pivot to oracle.
Posted: Thu May 03, 2007 1:27 am
by priyadarshikunal
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.
Posted: Thu May 03, 2007 3:18 am
by ray.wurlod
For a mere few cents per day you can be a premium member and help to fund the bandwidth costs of DSXchange.
Posted: Thu May 03, 2007 4:44 am
by priyadarshikunal
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.
Posted: Thu May 03, 2007 7:12 am
by chulett
Answer the question you could see: Is that correct?
Posted: Thu May 03, 2007 4:40 pm
by ray.wurlod
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.
Posted: Mon May 07, 2007 4:01 am
by priyadarshikunal
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