Hi,

I was wandering if anyone could recommend good naming convention for data
warehouse tables.

I have seen options:

1. dimTable1, dimTable2, factTable1, factTable2

2. dim.Table1, dim.Table2, fact.Table1, fact.Table2

How do you deal then with tables that could be both fact and dim?

Thanks

Vimmas