Input record sequence number
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
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. ...
And If I have only 175 records in today's file and say the last record errors. I cannot say them the record sequence number is 177, which will give no meaning to them.
Arun
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
You are the creator of your destiny - Swami Vivekananda
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
sequence number
recieved this code, hope it helps:
Code: Select all
(1 + @INROWNUM + MOD(@PARTITIONNUM, @NUMPARTITIONS)) + ((@INROWNUM -1) * (@NUMPARTITIONS -1))