Partioning the Table into .net - Creating columner database.
- by Omky
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.
