Page 1 of 1
I required merger Sequential or hash file
Posted: Tue Jun 29, 2004 6:50 am
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?
Re: I required merger Sequential or hash file
Posted: Tue Jun 29, 2004 7:46 am
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?
Posted: Tue Jun 29, 2004 7:50 am
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.