DSXchange

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

There is a property called RowNumberColumn. Please look at properties.

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.

You can generate the current row number if you are careful with any partitioning.

You are talking about not in the sequential file stage but in the following stage, eg, a transformer, right?

Yes, via a stage variable in a transformer.