Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Stage vs PSA Naming Conventions

2 posters

Go down

Stage vs PSA Naming Conventions Empty Stage vs PSA Naming Conventions

Post  Space Cowboy 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

Back to top Go down

Stage vs PSA Naming Conventions Empty Re: Stage vs PSA Naming Conventions

Post  BoxesAndLines Wed Jun 24, 2009 11:45 am

What does PSA stand for?
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Stage vs PSA Naming Conventions Empty Re: Stage vs PSA Naming Conventions

Post  Space Cowboy 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

Back to top Go down

Stage vs PSA Naming Conventions Empty Re: Stage vs PSA Naming Conventions

Post  BoxesAndLines Wed Jun 24, 2009 12:40 pm

Got it. I call that ODS.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Stage vs PSA Naming Conventions Empty Re: Stage vs PSA Naming Conventions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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