pivot transformation 中文意思是什麼
pivot transformation
解釋
取主轉移- pivot : n 1 【機械工程】交樞,樞軸,支軸,磨經〈磨的回轉軸〉;【物理學】支點,支樞;扇軸兒。2 樞要,中樞...
- transformation : n 轉變,變化;變形;【生物學】(尤指昆蟲的)轉化,變態,改造,改革;變質;【數學】變換;【電學】...
-
The pivot transformation makes a normalized data set into a less normalized but more compact version by pivoting the input data on a column value. for example, a normalized
通過透視列值的輸入數據,透視轉換將規范化的數據集轉變成規范化程度稍低、但更為簡潔的版本。 -
An ssis transformation can also pivot relational data and transform it into a less - normalized format that is more compatible with the table structure in the data warehouse
Ssis轉換還可以透視關系數據,並將其轉換為不太規范的格式,以便更好地與數據倉庫中的表結構相兼容。 -
The pivot transformation uses the properties on its input and output columns to define the pivot operation
透視轉換使用其輸入列和輸出列的屬性來定義透視操作。 -
The pivot transformation includes the
透視轉換包括 -
Configuring the pivot transformation
配置透視轉換 -
By pivoting the data set on the product column, the pivot transformation can output a data set with a single row per customer
此時,如果對產品列透視數據集,透視轉換可以輸出每個客戶只有一行的數據集。 -
If the data is not sorted, the pivot transformation might generate multiple records for each value in the set key, which is the column that defines set membership
如果數據未經排序,那麼透視轉換就可能為設置鍵(即定義集成員關系的列)中的每個值生成多個記錄。例如,如果對
分享友人