The pivot is an dimensional data operation where rows and columns are interchanged.
Pivot is also known as:
This operation is typically performed by the visualization tool.
wiki/Cross tabulation (or crosstabs for short) is a statistical process that summarises categorical data to create a contingency table. Some entries may be weighted, unweighted tables are commonly known as pivot tables.
select cust_id,
max(decode(day,trunc(sysdate-0)),sales)) day1,
max(decode(day,trunc(sysdate-1)),sales)) day2,
.....
max(decode(day,trunc(sysdate-6)),sales)) day7
from fact,dim
where <join>
and day >= sysdate minus whatever....
group by cust_id;
Copy > Paste Special > Transpose
Disadvantage of this structure as a storage structure, if a pivot is used to represent different possible values of a column.
If you want:
Furthermore, it's not a third normal form. Then if the data is sparse, you cannot save it in a parse form and you end ups using a lot of storage for nothing and can degrade seriously then the performance.