In this series of modules, you will use IBM InfoSphere FastTrack to create an application that identifies customers with high value to your business. You will. InfoSphere FastTrack provides capabilities to automate the workflow of your data integration project. Users can track and automate multiple. IBM InfoSphere FastTrack accelerates the design time to create source-to-target mappings and to automatically generate jobs. Mappings and jobs are then.

Author: Moogulrajas Gagrel
Country: Somalia
Language: English (Spanish)
Genre: Video
Published (Last): 7 October 2015
Pages: 468
PDF File Size: 14.92 Mb
ePub File Size: 18.39 Mb
ISBN: 402-6-30075-739-7
Downloads: 21484
Price: Free* [*Free Regsitration Required]
Uploader: Arasho

Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation

The IT team was faced with supporting disparate data environments for its core banking system, which made customer data difficult to manage. You will experience how InfoSphere FastTrack increases the ease and efficiency by which you create mapping specifications.

InfoSphere Infosphsre InfoSphere FastTrack generates messages relating to errors that occur during importing, validation, mapping, and job generation. You can also save the job in the metadata repository. Scenario for mapping data This scenario shows how an organization used InfoSphere FastTrack to consolidate, map, and transform data to solve a business problem.

The data is in these tables: Users can track and automate multiple data integration tasks, shortening the time between developing business requirements and implementing a solution. Extract customer information from the tables in the BANK2 schema The customer information that First Midwest wants to integrate into its banking system is in multiple tables.

You also can generate reports that provide details about mapping specifications that you create as you create the application.

You then integrate the customer data from the BANK 3 subsidiary into the database containing the standardized customer information. Through the modules, you create specifications and build an application to identify gold and platinum customers for marketing and customer service.


Scenario for mapping data

In Module 1, you prepare for the tutorial. First Midwest is a financial institution that grew by acquisition. Importing mapping specifications These topics describe how to import mapping specifications from other application sources, modify the mapping specifications in InfoSphere FastTrackand then export the mapping specifications fastttrack that you can share your specifications with other team members.

Move gold customer data appropriate for marketing such as name, address, and gender from the bankdemo.

Scenario for mapping data

Table-level specifications Provides the ability to define joins, filters and case statements, and use joins that are found during profiling with IBM InfoSphere Information Analyzer. BANK 1 Holds only checking accounts.

Modules in this tutorial Module 1: Job generation automatically derives fsttrack extract, transform, and load flow from business requirements. Generating jobs These topics describe how to generate jobs from mapping specifications.

First Midwest subsidiaries and the plan for how the data flows. Imported metadata is viewable by all suite users and can be used by all suite components. First Midwest defines two levels of high-value customers. Therefore, account balances for both checking and savings accounts must be aggregated to compute the total account balance for a customer.

The business analysts can also use InfoSphere FastTrack to discover and optimize mapping by using existing data profiling results from the metadata repository. Automated discovery of relationships Helps you to create customized discovery algorithms to find exact, partial, and lexical matches on corresponding column names across source to target structures.


Generate jobs that are used to build applications Generate reports to view mapping specifications statistics and characteristics. Import data from Microsoft Excel spreadsheets and. They also explain how to migrate from previous releases. With the mapping editor, you create mappings by selecting source columns and target columns from data source tables. First Midwest wants to ensure that gold customers are offered new investment opportunities and that platinum customers are given premium customer service when they call in with issues.

Infozphere Administration These topics describe infospuere to perform general administration tasks, such as setting up user security, managing sessions, reviewing logs, scheduling activities, and managing assets.

You can use any existing, shared metadata column or any term from the business glossary as sources or targets. Setting or checking status You can indicate the status of mapping specifications and specific source-to-target mappings by using the mapping editor.

You infospherw specify parameters within report templates so that you can obtain specific mapping specification information tailored to your requirements. Getting started with the consoles These topics introduce the console and the Web console, and they explain how to use each to complete administrative tasks.

Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation

Now you must integrate the customer data from Bank 3. Creating specifications Tasttrack financial institution recently acquired several companies. Bank 2 also keeps track of demographic data about customers in a separate table, BANK2.