Hello,
Could you please advise a good method to name fields in analytical data modeling?
For example, I have CustomerID in Customers and Orders tables.
In production database these names are the same (CustomerID in Customers and the same in Orders).
In analytical datamodel I want to differentiate these Ids, because it gets very confusing (at least to me).
For example, several approaches.
Customers-CustomerID and Orders-CustomerID
Another approach
CustomerID.Customers and CustomerID.Orders
In another words, I want to preserve the table name (full resolution), and in some cases even database name, like CustomerID.Customers.Accounting and CustomerID.Customers.Marketing
Otherwise it is getting pretty confusing in reports to understand to what database, table or file this field is from.
Maybe I'm on a wrong path here? Any suggestions or links to common practice would be appreciated.
