Naming Standards for Table Definitions

[bigpoppa]

I am trying to come up with a naming standard/directory structure for Table Definitions within DataStage. I have a couple of options.

Table Definition directories could be organized by:
1. the same convention that jobs are organized
2. by Source Type (the DS way)
3. by Source Name
??

Naming Table Definitions
1. By source name

Does anyone have any input on naming standards that worked for their DS projects?

Thanks,
BP

[rasi]

Hi,

The naming standard depends from project to project. However a generic standard for the table definitions could be like

-ProjectName (Your Project Name)
--StagingName (Staging Area 1, 2 etc)
--- DataSource (Oracle, SQLServer, Hash, Sequential etc)
-- TableName (Name should be your Database Table Name)
--DataWarehouse
--- DataSource (Oracle, SQLServer, Hash, Sequential etc)
-- TableName (Name should be your Database Table Name)
--DataMart
--- DataSource (Oracle, SQLServer, Hash, Sequential etc)
-- TableName (Name should be your Database Table Name)

Thanks
Rasi