Posted: Thu Sep 09, 2010 5:16 pm
Ask yourself whether uniqueness is sufficient. If it is, gaps in the numbers are completely irrelevant.
This is the current scenario Anbu. But the jobs run for a longer time. Say the job with sequential mode runs nearly an hour and making it parallel, it runs less than 10 minutes.anbu wrote:Run the parallel transformer in sequential way and use @INROWNUM
No Ray. I want the Input records sequence number. The requirement is, we have an error processing and which ever record errors, I need to cature the Input record sequence number and store it in a table for further investigation/reporting.ray.wurlod wrote:Ask yourself whether uniqueness is sufficient. If it is, gaps in the numbers are completely irrelevant. ...
Or finish your processing in one job without sequence number if it is ok for your requirement. In second job create seqeunce number using transformer running in sequential wayarunkumarmm wrote:This is the current scenario Anbu. But the jobs run for a longer time. Say the job with sequential mode runs nearly an hour and making it parallel, it runs less than 10 minutes.anbu wrote:Run the parallel transformer in sequential way and use @INROWNUM
I need to map this sequence number to the records which is errored out.anbu wrote:Or finish your processing in one job without sequence number if it is ok for your requirement. In second job create seqeunce number using transformer running in sequential way
Code: Select all
(1 + @INROWNUM + MOD(@PARTITIONNUM, @NUMPARTITIONS)) + ((@INROWNUM -1) * (@NUMPARTITIONS -1))