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.
|Published (Last):||18 July 2013|
|PDF File Size:||2.35 Mb|
|ePub File Size:||12.96 Mb|
|Price:||Free* [*Free Regsitration Required]|
First Midwest wants to ensure that gold customers are offered new investment opportunities and that platinum customers are given premium customer service when casttrack call in with issues. You use a simple user interface to complete business requirements, track work, and then translate the specifications directly into integration code for use by the InfoSphere Information Server data integration engine. You will access this database in Module 1, in Lesson 1. Generating jobs These topics describe how to generate jobs from mapping specifications.
You then use the data source to create source-to-target mappings. You can obtain additional data from columns for your mapping specification by using lookup tables. The following steps illustrate the sequence of actions: The remaining modules each take about minutes to complete.
Where InfoSphere FastTrack fits in the suite architecture You can use InfoSphere FastTrack to track and automate efforts that span multiple data integration tasks from analysis to code generation, shortening the time from business requirements to solution implementation.
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. You can monitor recent activities of a mapping specification.
These tasks are required to build the application that identifies high-value customers:: Now you must integrate the customer data from Bank 3. First Midwest subsidiaries and the plan for how the data flows.
By using InfoSphere FastTrackthe IT team specified data relationships and transformations that the business analysts used to create specifications, which consist of source-to-target mappings. Users can track and automate multiple data integration tasks, shortening the time between developing infosphefe requirements and implementing a solution.
You can also view detailed properties information including an expandable view of the fastyrack in the IBM InfoSphere Information Server metadata services repository. Create mapping specifications that map data from the source to the target tables.
The standardized information is used to build information about platinum customers for the customer service department and information about gold customers for marketing.
Set up the tutorial environment You must prepare your system to run the tutorial. 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 will experience how InfoSphere FastTrack increases the ease and efficiency by which you create mapping specifications. Move gold customer data appropriate for marketing such as name, address, and gender from the bankdemo.
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 specifications link the customer data fields to key business terms and transformation rules that are used to compute new data fields. Creating reports These topics describe how to create reports that present data at the mapping specification level. Components in the suite.
Import data from Microsoft Excel spreadsheets and. Time required In the first module, you set up your environment, and the time required depends inrosphere your current environment.
The IT team was faced with supporting disparate data environments for its fasttrak banking system, which made customer data difficult to manage. The messages listed in this section describe the errors, explain why they occurred, and suggests actions that address the messages.
BANK 2 Holds checking and savings accounts.
IBM InfoSphere FastTrack
Managing projects These topics describe how to create projects and modify project properties. 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. By linking information in a shared metadata repository, data is accessible, current, and integrated across the data integration project.
The business analysts can also use InfoSphere FastTrack to discover and optimize mapping by using existing data profiling results from the metadata repository. You can specify parameters within report templates infospere that you can obtain specific mapping specification information tailored to your requirements.
Scenario for mapping data
These lookup definitions are searchable and designed for reuse. Creating specifications A financial institution recently acquired several companies. Extract customer information from the BANK1 database In this module, you begin to consolidate relevant customer data into a table that follows the standard model of the company.