Stage vs PSA Naming Conventions

Space Cowboy at 14h46
24
Jun
2009
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 ware
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I'm a little confused about the naming convention for the TV posters and banners. Is the name for a banner season-all.tbn or folder.jpg? Reason being I'm wondering if I can have both the banner and poster as options for the library. I personally used
Hi Billy I downloaded the most recent version 2.085 and am having a number of problems. I read in the anouncement for 2.071 that if I have fanart and poster tbn's not named with the default naming convention then it would offer to rename them for me
I was somewhat confused while reading this: The DWH ETL Toolkit, On page 116, Chapter 4, Cleaning and Conforming, Assumptions, in the first bullet "...customer information from various sources initially can be staged in a table [. . .] whose
If I have a fact table with a "counter" fact, for example a customer places an order, but then goes back and changes parts of that order any number of times, I want to store how many times the customer changed his/her order. The grain of the
Is it a best practice to truncate a stage table before every load? --- RPC
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Stage vs PSA Naming Conventions"

This topic has been viewed 1078 times.

Last message :
24/06/2009 at 14h46 by "Space Cowboy"