Production data flows regularly to data warehouses, where analysts from different parts of the organization can use it without jeopardizing live data. Continuous monitoring of the migration process can quickly identify migration issues before they pose a serious threat. The Join and Compare commands are essential for this purpose.
When new systems are implemented, those commands can also be used to verify that the data has successfully migrated with no integrity issues.
Key fields can often be in varying formats from one system to another. To make them suitable for comparison, there are a number of functions that can be used in computed fields to normalize the data: • SortNormalize • Normalize • Upper • Lower • Include • Exclude • String • Value • Zoned • AllTrim • Compact • Split • Substring
Additional Popular Analytics Tests
No two organizations are identical, but the vast majority consider many of the same tests. Learn more about these popular analytics tests