Hi Everyone,
I am kind confused about this partioning.
Lets take a cube A- In the FFACTTABLE I am seeing like 590,00000
EFACTTABLE 0
But I am seeing some posts saying that Physical partioning is done on the Etable based on CALMONTH or FISCPER.
So my question if there are no records on E facttable how can we do physical partioning.
I know the concept of Compression and how it works. Only if you compress the data will be sent to F table to E-table.
Can anybody explain me in detail?
Thanks very much.