The unpivot transformation makes an unnormalized dataset into a more normalized version by expanding values from multiple columns in a single record into multiple records with the same values in a single column 逆透視轉(zhuǎn)換將來自單個記錄中多個列的值擴展為單個列中具有同樣值的多個記錄,使得非規(guī)范化的數(shù)據(jù)集成為較規(guī)范化的版本。
We can reach those aims by mining and analyzing the records that are formed through getting in touch with customers . however because different departments did their own jobs and did not pay enough attention to customer mining and analysis , there are kinds of unnormalized and redundant data 但是由于企業(yè)各部門的分頭行事和最初對客戶信息挖掘和分析的不足夠重視,在這些記錄中存在著各種非規(guī)范化的數(shù)據(jù)和冗余的數(shù)據(jù)。