I have big fact table 2 billions rows and 19 dimensions ( product dimension is big 450 millions, another two dimensions are 100 millions each rest small dimensions table)
Can some one help me on data distribution for this scenarios ?
Asked
Active
Viewed 66 times
0
-
more info needed - please update question with table layouts (ddl) and expected common queries. also any issues with performance if you have them. – Jon Scott Dec 18 '17 at 09:58
-
I just want to know the generic approach – diptiranjan pradhan Dec 18 '17 at 15:44
-
flagged as too broad – Jon Scott Dec 18 '17 at 16:22