Thanks, David for your thoughts and explaining reasons why you use them. I do see the advantage of having them for partitioning purposes although you can theoretically partition by using the date key as well. I'm not too sure how useful they are for ETL unless doing auditing as by their nature, surrogate keys won't exist on source systems, but then again I'm not too experienced on data warehouses which is why I'm asking for people's opinions.