I need to generate sequence number in my input file. say if i have 10 records they should have sequence number 1, 2, ,3 .... 10. the file is being run on 5 node configuration system. how can I assign it while file is being split between 5 nodes?
Create an extra column in your sequential stage and set the option Row Number column in Properties tab to this extra column. This will generate sequential number. But the number starts from zero. You can add one to it in the transformer
You are the creator of your destiny - Swami Vivekananda
anbu wrote:Create an extra column in your sequential stage and set the option Row Number column in Properties tab to this extra column. This will generate sequential number. But the number starts from zero. You can add one to it in the transformer
anbu,
But it's running on multiple node so what would happen eventually is records on each node would have sequence number as per that node only... i need to maintain it across the nodes on file level.
Sequential stage runs sequentially and generates sequential row number unless you changed the default setting of Number of readers per Node or Read from Multiple nodes.
You are the creator of your destiny - Swami Vivekananda