problem in implementing pivot stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
problem in implementing pivot stage
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
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
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: problem in implementing pivot stage
yes, I am getting error while dragging the link from pivot to oracle.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Since I am not a premium member, I am unable to see the whole reply.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 ...
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
I can't see any output link.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. ...
for that i have compiled the job,
the error is:
there must be an stream output link
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.