if you are trying to find out which side I am on when it comes to the DW design approach dichotomy then I would say this is not the right...

if you don't have a choice but to pull data directly from an OLTP system or a non multi dimensional data source to the cube then that's OK to model...

Yes you are right. I believe, as a best practice any environment where surrogate keys are generated to track dimension or for that matter for any form of versioning are...

Personally, I can't think of a good scenario where you will want to make these two tables a part of a recurring full load ETL processes.

Actually in my initial...