Stage vs PSA Naming Conventions

I have a little difference of opinion with my current team members concerning naming conventions between Stage and PSA. Int he years that I've been in BI/DW, I've learned that it is the norm that the Stage is basically an extact representation of the source system information with no naming convention changes. However, the PSA will typically take on more 'English' type naming conventions (example would be if the source is SAP), then of course the warehouse takes on that same naming convention as the PSA.

My team members argues that simply because we merge data sources in the PSA, we shouldn't change the orginal naming convention from the source system. So basically, the Stage would look identical to the PSA.

I'm looking for any type of documentation that proves that my though process matches the standard methodology adopted by most DW groups and consulting companies.

Thanks!

What does PSA stand for?

BoxesAndLines wrote:What does PSA stand for?

Persistent Staging Area

Common terminology in DW

Got it. I call that ODS.