How to keep the record order with Surrogate key generator
Posted: Fri Feb 05, 2010 9:52 am
Hi,
I want to add a sequence to records in a flat file with surrogate key generator.
My job design is simple:
My input file is:
and what I want to get as the output is:
With surrogate key generator, I can realize that. But the problem is that the order of output is not certain. It's random. What I get finally is:
I have tried to set the execution mode of surrogate key generator stage as sequential. But when I run the job, there is an error saying:
Can anybody give me a suggestion on this issue?
Thanks in advance!
NSIT
I want to add a sequence to records in a flat file with surrogate key generator.
My job design is simple:
Code: Select all
sequential file --> surrogate key generator --> sequential file
Code: Select all
aaa
bbb
ccc
ddd
eee
Code: Select all
1 aaa
2 bbb
3 ccc
4 ddd
5 eee
Code: Select all
1 bbb
2 aaa
3 ddd
4 ccc
5 eee
Code: Select all
Surrogate_Key_Generator_22: Error when checking operator: Input data set on port 0 has a partition method, but the operator is not parallel.
Thanks in advance!
NSIT