I required merger Sequential or hash file

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
vikas gupta
Participant
Posts: 30
Joined: Wed Mar 24, 2004 1:28 am

I required merger Sequential or hash file

Post by vikas gupta »

I have sequential file, which have three records against one id with different values. Is it possible through datastage to convert three records into one record against id?
Top
sanjay
Premium Member
Premium Member
Posts: 203
Joined: Fri Apr 23, 2004 2:22 am

Re: I required merger Sequential or hash file

Post by sanjay »

use pivot stage

Sanjay

vikas gupta wrote:I have sequential file, which have three records against one id with different values. Is it possible through datastage to convert three records into one record against id?
Top
chucksmith
Premium Member
Premium Member
Posts: 385
Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:
Contact chucksmith

Post by chucksmith »

Be aware that if you make a mistake in the derivation of a pivot stage, it will only be reported to you at run time as and INFO message!

Also, earlier release had problems pasting into the derivations. Save often.

The pivot stage is the correct approach to your problem.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”