Split the column into rows

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ssnegi
Participant
Posts: 138
Joined: Thu Nov 15, 2007 4:17 am
Location: Sydney, Australia

Post by ssnegi »

pivot them into rows
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It would be helpful if you... elaborated.
-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 »

Hmmm... I was wondering if there was a way to use a Hashed File stage to do the dynamic normalization since that's an option there for account-based hashed files. Perhaps? Or does the need to join two rule that out?
-craig

"You can never have too many knives" -- Logan Nine Fingers
bharathappriyan
Participant
Posts: 47
Joined: Fri Sep 23, 2005 6:01 pm

Post by bharathappriyan »

Hi Ray/Chulett,

Thanks a lot for your reply. But i am not able to read your messages.

Thanks,
Bharathappriyan
bharathappriyan
Participant
Posts: 47
Joined: Fri Sep 23, 2005 6:01 pm

Post by bharathappriyan »

Hi Ray/Chulett,
I was able to resolve this. I used the Hashed file stage. In that i used the type as MS.

I really appreciate all for the help.

Thanks,
Selva
Post Reply