Archives of the TeradataForum
Message Posted: Mon, 09 Feb 2004 @ 11:30:02 GMT
I need a solution to the following problem.
col1 | col2 1 abc 1 def 1 sdf 1 fgh 2 ggh 2 ddd ------- -------
the o/p desired is :
col1 | col2 1 abcdefsdffgh 2 gghddd --- ---
At the moment I'm running a pretty straight forward procedure that does the works for me. However, performance is a serious concern. I have 30-40 million unique values for col1 and 1-200 values (this number is a variable for each col1 value) in col2.
The client is MVS where I need to FEXP the results.
Any suggestions on alternate ways of implementation / improving the performance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|