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)換將來(lái)自單個(gè)記錄中多個(gè)列的值擴(kuò)展為單個(gè)列中具有同樣值的多個(gè)記錄,使得非規(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è)各部門(mén)的分頭行事和最初對(duì)客戶信息挖掘和分析的不足夠重視,在這些記錄中存在著各種非規(guī)范化的數(shù)據(jù)和冗余的數(shù)據(jù)。