Oracle Database Discussions

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!