Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best practice of metadata table in data warehouse environment ?

645300Mar 11 2011 — edited Mar 11 2011
Hi guru's,


In datawarehouse, we have 1. Stage schema 2. DWH(Data warehouse reporting schema). In stageing we have about 300 source tables. In DWH schema, we are creating the tables which are only required from reporting prespective . some of the tables in stageing schema, have been created in DWH schema as well with different table name and column names. The naming convention for these same tables and columns in DWH schema is more based on business names.

In order to keep track of these tables we are creating metadata table in DWH schema say for example

Stage                DWH_schema
Table_1             Table_A          
Table_2             Table_b
Table_3             Table_c
Table_4              Table_D
My question is how do we handle the column names in each of these tables. The stage_1, stage_2 and stage_3 column names have been renamed in DWH_schema which are part of Table_A, Table_B, Table_c.

As said earlier, we have about 300 tables in stage and may be around 200 tables in DWH schema. Lot of the column names have been renamed in DWH schema from stage tables. In some of the tables we have 200 column's

so my concern is how do we handle the column names in metadata table ? Do we need to keep only table names in metadata table not column names ?


Any idea will be greatly appriciated.

Thanks!
This post has been answered by 23ai on Mar 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2011
Added on Mar 11 2011
8 comments
740 views