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: Voodookora Taukree
Country: Peru
Language: English (Spanish)
Genre: Marketing
Published (Last): 15 May 2008
Pages: 362
PDF File Size: 19.20 Mb
ePub File Size: 19.1 Mb
ISBN: 190-3-67340-466-8
Downloads: 82740
Price: Free* [*Free Regsitration Required]
Uploader: Kagam

Tracking changes for auditing You can track and record any changes you make in InfoSphere FastTrack for auditing purposes. InfoSphere FastTrack InfoSphere FastTrack generates messages relating to errors that occur during importing, validation, mapping, and job generation.

Components in the suite. Creating specifications A financial institution recently acquired several companies. 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. Message reference These topics describe warning and validation messages, explain why they occur, and recommend actions to take. Users can track and automate multiple data integration tasks, shortening the time between developing business requirements and implementing a solution.

By automating the flow of information and increasing collaboration, development time is reduced. With the job generation wizard, you can generate multiple specifications into a single job. 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.

The specifications link the customer data fields gasttrack key business terms and transformation rules that are used to compute new data fields. Working with mapping specifications. HTML Administering 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. BANK 3 Holds only savings accounts. Identify gold customers as level B and platinum customers as fasttrxck A.


Getting started with the consoles These topics introduce the console and the Web console, and they explain how to use infossphere to complete administrative tasks. The standardized information is used to build information about platinum customers for the customer service department and information about gold customers for marketing.

Import data from Microsoft Excel spreadsheets and. You can monitor recent activities of a mapping specification. You can also delete metadata from the metadata repository. Extract customer information from the tables in the BANK2 schema The customer information that First Midwest wants to integrate into its banking system is fasttraci multiple tables.

You can drag tables or columns into the mapping editor and then associate more data, such as business terms or transformation operators, to the columns.

Infsphere IT team was faced with fatstrack disparate data environments for its core banking system, which made customer data difficult to manage. 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.

InfoSphere FastTrack assets You can use the -fasttrack option of the istool command in a command-line interface to move InfoSphere FastTrack projects and related assets across different installations of InfoSphere Information Server.

You can also export mapping specifications into Microsoft Excel spreadsheets and.

You can also use a discover function to find column matches and create relationships between columns. The following components and applications must be installed on your system. Now the priority of First Midwest is to regain its customer base by improving its view of customer data. First Midwest subsidiaries and the plan for how the data flows.

Infsphere metadata is viewable by all suite users and can be used by all suite components. A financial institution recently acquired several companies. 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. First Midwest is a financial institution that grew by acquisition.

Getting started After installing InfoSphere FastTrackyou start the client and configure your system. Fasttrxck each fasttracm the acquired companies used different business terminology, the business analysts constantly revised existing term and definitions. For this tutorial, you will follow a fictional scenario about the First Midwest company.


Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation

InfoSphere FastTrack offers the following capabilities: Scenario for mapping data This scenario shows how an organization used InfoSphere FastTrack to consolidate, map, and transform data to solve a business problem. Time required In the first module, you set up your environment, and the time required depends on your current environment.

Flexible reporting capabilities Provides information on column-level mappings, table-level mappings and lookups. As First Midwest focused on acquisition activities, fastttrack competition pulled away several of their high-value customers. Troubleshooting These topics describe log files, administrative tools, and how to troubleshoot issues such as problems with authentication and configuration.

Customers might have checking and savings accounts.

InfoSphere FastTrack capabilities

System requirements The following components and applications must be installed on your system. The messages listed in fasttraxk section describe the errors, explain why they occurred, and suggests actions that address the messages. The data is in one table: HTML Administration These topics describe how to perform general administration tasks, such as setting up fasttraack security, managing sessions, reviewing logs, scheduling activities, and managing assets.

First Midwest defines two levels of high-value customers. In Module 1, you prepare for the tutorial.

Reports You can create reports that you can distribute to authorized users. Business analysts use InfoSphere FastTrack to translate business requirements into a set of specifications, which data integration specialists then use to produce a data integration application that incorporates the business requirements.

Creating reports These topics describe how to create reports that present data at the mapping specification level. Creating mapping specifications You create mapping specifications that consists of source-to-target mappings.