Code: Select all
key SEQ VALUE
123 1 33.45
123 2 44.32
.......
123 48 34.65
124 1 43.21
124 2 09.54
.......
124 48 98.54
Code: Select all
key VAL1 VAL2 .... VAL48
123 33.45 44.32 34.65
124 43.21 09.54 98.54
I tried hash partitioning and sorting but it dint work. Interestingly, I am playing with couple of records at the moment, interestingly for the first records it is failing but the sequence is getting right for 2nd record (sort of unpredictable behavior).
When I run this job in Sequential mode it run fine when I use sort merge collector method at Pivot Stage. But its not working in Parallel mode.
Any help on this would be greatly appreciated.