What is the output of the RecNo function when used in a data table?

The output of the RecNo function when used in a data table indeed yields an integer for the row being read. This function is designed to provide the current record number of the data being processed during the loading of a script. Each time a new record is read in the data load process, the RecNo function increments by one, effectively acting as a simple counter for the rows being processed at that moment.

This functionality is particularly useful when you want to keep track of the position of records within a dataset or need to perform operations that depend on the relative position of a row. Since RecNo gives a direct reference to the row index during the load phase, it is commonly leveraged in scenarios where ordering or identifying a specific row is necessary.

In contrast, the other options do not accurately represent the function's purpose. Unique entries would imply a distinct count rather than a positional identifier, while a unique numeric identifier for columns does not align with the nature of RecNo, which strictly deals with rows. Lastly, the concept of the total number of records processed refers to an aggregate count, which is not the function's goal; RecNo operates at an individual record level rather than providing a summary statistic.