Other correlation activities are ones that can be supported directly within the data warehouse environment:
- Code set translations ensure that a user can reference any data source using the approved corporate standard code set for some particular attribute.
- Cross-reference translates that allow two different identifiers for the same particular entity to be combined together.
- Transformation of one representation of a particular identifier into a matching representation somewhere else. For instance, if one system uses a 15 digit cost center that includes accounting unit, account, and sub account, the data warehouse should take that 15 digit string, break it into components, and match those against the information from the finance system.
Having a data warehouse to preexecute these kinds of correlation activities once and store the results for convenient use in tens of thousands of queries every month or even every day is a huge benefit to analysts through clear communication and improved performance.
#PragProWriMo word count: 46,141