Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created one view the backend which contains all dimensions and fact columns and wanted to create fact and dimension separated in my modelling ..
i follow Kimbel concept
thanks
Cool. do you have a question ?
can we spit view in dimension and fact columns
can we split view in dimension and fact columns
What do you mean by "view" ?
Try to be precise in your question please.
Try to give some example of the tables, the tables structures, the expected result
this is view
col1 | col2 | col3 |
a | prod1 | 20 |
b | prod2 | 22 |
c | prod3 | 26 |
col1 and col3 in Table1
col1 and col3 in table 2
without loading multiple time