From my own perspective I have observed the following common issues (even if they shouldn't be common).
- Inconsistent formats used for the same data element in different systems.
- Inconsistent definitions of the same data in different systems.
- Inconsistent values of the same data in different systems.
This is why many organisations have data warehouses and why people like me map between the different systems and the data warehouse so that some ETL code can be used in order to bring it into a common data format, data type and data values so it can be joined easily and you can compare like with like.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.