Would like to invite suggestions from experts on modeling hierarchies with dynamic levels.
I have read through a lot of articles which discuss about LEFT RIGHT numbering approach , mapping approach
and denormalized table structures for modeling this kind of data. Please share your experiences regarding the way you implement such kind of hierarchires.
Thanks for the inputs..I have a fair amount of idea about this approach and its explained in Kimballs tool kit as well. I just wanted to know if you faced any challenges while loading the Bridge table..Like loading the Levels to the root and all. You use ETL tools to load that or plain SQL queries.