Data reorganization functions provide the ability to join, merge, and denormalize preprocessed results into a wide analytic data set, as well as select a subset of the rows in a table. The result of these functions is a new restructured table that has been built from one or more existing tables, a subset of the rows in a table, or a combination of both.
Identity columns (for example, columns defined with the attribute GENERATED AS IDENTITY) cannot be analyzed by data reorganization functions that create an output or temporary table, with the exception of the merge function.
The data reorganization functions include the following options:
- Denorm — Create a new denormalizing table by removing key columns.
- Join — Join tables or views by columns into a combined result table.
- Merge — Merge tables or views by rows into a combined result table.
- Sample — Create a sample analysis based on a specified number of table rows or a fraction of the total number of rows.