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
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 and col3 in Table1
col1 and col3 in table 2
without loading multiple time
Retrieving data ...