I have a fact table that need self-join query in Datawarehouse environment (star schema). Is it the best practice to have one table and use self-jon query? Or spit the table ( more nomalized..but I am not sure how)?
What is the best database design that require self-join query (subquery or CTE) to get the best performance?