Technology

Technology

• Identity Management: Terminated Employees

  Use a Join to match terminated employee data from HR to the Active Directory file to identify still-active accounts after employee departures.
  
  

• SOD

  Create a table containing each employee's pairs of duties with a many-to-many Join. Then use a matched Join to identify pairs of employee duties that are prohibited.
  
  

• Event Log Analysis

  Event logs tend to be unstructured. Create a "flat" file using static conditional fields to render the data in a format that can readily be analyzed.

• System-Level Settings

  Extract system settings at regular points in time, then use the Compare command to identify any changes that may have taken place.
  
  

• Data Integrity

  Data should be rigorously tested prior to analysis to determine whether it is appropriate to use.

  There are a variety of tests that can be executed to identify potential data issues. 

• Data Migration

  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.

   

   

• Data Normalization

  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