[Netezza] Meaning of tables prefixes/labels

Hi all,

I usually work with MySQL and now I have to populate Netezza database.
I just see the SQL script to create Netezza tables and I noticed the use of the following labels:
- TWH;
- ODS;
- STG;
- DIM;
- GES.

I guess the meaning of some of them, but it will be very interesting to have detailed information about them.

Thanks in advance.
Richard Coffree-commerce Product ManagerAsked:
Who is Participating?
aikimarkConnect With a Mentor Commented:
my guess...
TWH - The WareHouse
ODS - Operational Data Store
STG - STaGing
DIM - DIMension

I don't know about GES.
tbsgadiConnect With a Mentor Commented:
total working hours
OpenDirectory Service/ operational data store
Stage / Software Technology Group
Global Experience Specialists / Guess?, Inc

johnsoneConnect With a Mentor Senior Oracle DBACommented:
Those prefixes are not specific to Netezza.  They are names that were made for the tables.

Typically, ODS would be Operational Data Store, DIM would be a dimension table and STG would be a staging table.  TWH and GES I haven't seen before.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.