Hello Geeks,

I am developing some tool for BI. There are terms like Fact, Dimensions and Measures. My application will connect to the normal database and read the data from that table. Now, I want to convert all this data into columnar database. That is all the columns from this table will be transfer into 3 tables each. Consider below table:-

ID    Product  
1      XYZ  
2      ABC  
3      ABC   

Now, I want to convert the Product column i.e. dimension into 3 tables. dim_product_table:-

ID      Product  
1       XYZ  
2       ABC  

dim_product_fmk(fact map by key):- Where we will store key-value pair of

Key     Row  
1       1  
1       2  
2       3

dim_product_fmr(fact map by row):- The above table will be reversed.

Row     Key  
1        1  
2        1  
3        2

The another requirement is all above table should be generated dynamically and I should be able to JOIN all those.

Can anybody help me?

Thanks in advance.