Skip to main content

Select Blob Row Order By

Row Order definition to use for Blob source queries.

Options: ASC, DESC

The value sets the direction of the ROW_NUMBER() window function the generated load uses when selecting from staged-file and Persistent Staging sources: rows are partitioned by the key and ordered by the effective date in this direction, and the first row of each partition is kept. A value other than ASC or DESC is treated as ASC.

When to Change This Setting​

Keep the default ASC so the earliest row of each key/timestamp sequence is retained. Use DESC to retain the latest row instead.

SettingInteraction
Select Stage Row DistinctReplaces the row-number selection with a SELECT DISTINCT, in which case the order direction is not used
Delta Collapse RowsThe row collapsing that the row-number selection implements

Notes​

  • This setting is part of the Staging settings category.
  • The default value for this setting is ASC.