Scenario for mapping data

Financial services: Creating specifications

A financial institution recently acquired several companies. The IT team was faced with supporting disparate data environments for its core banking system, which made customer data difficult to manage. The business analysts worked extra hours creating source-to-target mappings by manually creating specifications that map customer data across multiple targets. Because each of the acquired companies used different business terminology, the business analysts constantly revised existing term and definitions.

By using InfoSphere Information Server, the IT team consolidated the business category and category terms, customer metadata (such as account balance and credit history data fields), and multiple data models in the metadata repository. The IT team used InfoSphere Information Analyzer to analyze the data and InfoSphere Information Governance Catalog to consolidate new and existing terms and definitions.

By using InfoSphere FastTrack, the IT team specified data relationships and transformations that the business analysts used to create specifications, which consist of source-to-target mappings. The specifications link the customer data fields to key business terms and transformation rules that are used to compute new data fields. As new customer data is added to the metadata repository, relationships can be discovered automatically and are linked to existing data records.

The business analysts can also use InfoSphere FastTrack to discover and optimize mapping by using existing data profiling results from the metadata repository. The business analysts can use these data profiling results to generate a job that a data integration specialist can modify by using the InfoSphere DataStage® and QualityStage® Designer client.