Hi,
1. Is there an option to add a ROW NUMBER COLUMN to the reading sequential file in the sequential file stage? I read and searched through the Sequential File Stage section from the Parallel Job Developer's Guide, Version 7.5.1, but didn't find any.
2. Is there any way to pass how many rows are read from the sequential file to next stages?
Thanks
ROW NUMBER for sequential file stage
Moderators: chulett, rschirm, roy
1. It looks like that option was added in the 8.x release, so no.
2. You can generate the current row number if you are careful with any partitioning. If you need to know the total number of records while the job runs, you'll need to count them ahead of time and pass the count in as a job parameter.
2. You can generate the current row number if you are careful with any partitioning. If you need to know the total number of records while the job runs, you'll need to count them ahead of time and pass the count in as a job parameter.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers