stages

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
rmeenakumari822
Participant
Posts: 30
Joined: Sat Oct 25, 2008 9:09 pm
Location: chennai

stages

Post by rmeenakumari822 »

Hi,

i have a source in flat file like
id code1 code2
101 a-1 a-2
142 b-1 b-2
...
and the required target column is
id code
101 a-1
101 a-2
142 b-1
142 b-2
.....
How can i get the required target?
pls help me to slove it

Thanks
priya
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Pivot stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
rmeenakumari822
Participant
Posts: 30
Joined: Sat Oct 25, 2008 9:09 pm
Location: chennai

Post by rmeenakumari822 »

can u explain me in detail?
priya
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Probably, but U hasn't been here for awhile.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The Pivot stage has a "Help" button that nicely explains how it works, suggest you give that a shot and come back with specific questions if you still have any.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Pivot stage also has its own manual, with very clear examples.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply