DW Handbook

This page shows the name of the stage, its description and how it was created (references)

Name Structuring2
Explanation Perform inter-record structuring tasks as well as tasks related to changing the shape of the input dataset
Task(s)
Structuring2_1_1:Filtering datasets by removing sets of records (Filter rows)
Structuring2_1_2:Filtering datasets by removing fields (Filter columns)
Structuring2_2_1:Shifting the granularity of the dataset through simple Aggregations performed on a dataset (GroupBy)
Structuring2_2_2:Shifting the granularity of the dataset through column-to-row pivot (Unpivoting) which returns columns of a dataset into a row format with repetition of other fields (Potter’s wheel defined it as a fold operation)
Structuring2_2_3:Shifting the granularity of the dataset through row-to-Column Pivots, which performs a reshape aggregation functionalities to the same dataset (Potter’s wheel defined a similar construct as an unfold operation)
Structuring2_3:Reorder records of a dataset (Sort)
Structuring2_4:Split Dataset into multiple datasets
Reshape:Shift the shape of the dataset (Transpose)
Reshape:Shift the shape of the dataset (Transpose)
Used In pm1 , pm3 , pm4 , ps2 , ps3
DW Constructs Reduce Dimensions , Remove Columns , Select Columns , Split Table , Aggregate , Filter Rows , Remove Column , Sort , Transpose

Back