Stage vs PSA Naming Conventions

View previous topic View next topic Go down

Stage vs PSA Naming Conventions

Post  Space Cowboy on Wed Jun 24, 2009 8:46 am

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!

Space Cowboy

Posts : 2
Join date : 2009-06-24

View user profile

Back to top Go down

Re: Stage vs PSA Naming Conventions

Post  BoxesAndLines on Wed Jun 24, 2009 11:45 am

What does PSA stand for?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Stage vs PSA Naming Conventions

Post  Space Cowboy on Wed Jun 24, 2009 12:11 pm

BoxesAndLines wrote:What does PSA stand for?

Persistent Staging Area

Common terminology in DW

Space Cowboy

Posts : 2
Join date : 2009-06-24

View user profile

Back to top Go down

Re: Stage vs PSA Naming Conventions

Post  BoxesAndLines on Wed Jun 24, 2009 12:40 pm

Got it. I call that ODS.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Stage vs PSA Naming Conventions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum