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):||27 December 2004|
|PDF File Size:||2.16 Mb|
|ePub File Size:||9.33 Mb|
|Price:||Free* [*Free Regsitration Required]|
Generate jobs that are used to build applications Generate reports to view mapping specifications statistics and characteristics. These customers were neglected or not treated preferably at First Midwest. You can also export mapping specifications into Microsoft Excel spreadsheets and. Job generation automatically derives an extract, transform, and load flow from business requirements. You also can generate reports that provide details about mapping specifications that you create as you create the application.
Troubleshooting These topics describe log files, administrative tools, and how to troubleshoot issues such as problems with authentication and configuration.
Creating specifications A financial institution recently acquired several companies. BANK 3 Holds only savings accounts.
Getting started in IBM InfoSphere FastTrack
Onfosphere Home and Mapping Specifications views provide profile and status information about specifications that are contained within projects, and access to tasks such as importing specifications, generating jobs, or publishing to a metadata repository. You then integrate the customer data from the BANK 3 subsidiary infosphfre the database containing the standardized customer information. System requirements The following components and applications must be installed on your system.
InfoSphere FastTrack tasks You can use InfoSphere FastTrack to automate the workflow of data integration projects by maximizing team collaboration, facilitating automation, and ensuring that projects are completed successfully and on time. InfoSphere FastTrack accelerates the design time to create source-to-target mappings and to automatically generate jobs.
Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation
Creating mapping specifications You create mapping specifications that consists of source-to-target mappings. Bank 2 also keeps track of demographic data about customers in a separate table, BANK2. Administering You can manage data source access, users and their access to InfoSphere FastTrackand manage access to product modules and components that are used with InfoSphere FastTrack. 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.
Now the priority of First Midwest is to regain its customer base by improving its view of customer data. A financial institution recently acquired several companies. You can also manage views and customize your environment.
Generating jobs These topics describe how to generate jobs from mapping specifications.
You will experience how InfoSphere FastTrack increases the ease and efficiency by which you create mapping specifications.
Time required In the first module, you set up your environment, and the time required depends on your current environment. Business analysts use InfoSphere FastTrack to translate business requirements into a set of specifications, which data infoosphere specialists then use to infospherd a data integration application that incorporates the business requirements. 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.
BANK 1 Holds only checking accounts. Getting started with fasttrac consoles These topics introduce the console and the Web console, and they explain how to use each to complete administrative tasks.
By using InfoSphere Information Serverthe IT team consolidated the business category and category terms, customer metadata such as account balance and credit history data fieldsand multiple data models in the metadata repository. HTML Configuring InfoSphere FastTrack This topic lists the configuration tasks in the order that you perform them, specifies the access level that you must have in order fasytrack complete tasks, and directs you to information about how to complete configuration tasks.
IBM InfoSphere FastTrack
First Midwest defines two levels of high-value customers. HTML Working with fasttracm specifications 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 so that you can share your specifications with other team members. Within a fastyrack, you can obtain statistics, such as the percentage of column mappings that have the source and target mapped, the number of source and target tables, and the types of transformations in a mapping specification.
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. You then use the data source to create source-to-target mappings. Infsophere Reference Message reference These topics describe warning and validation messages, explain why they occur, and recommend actions to take.
Now you must integrate the customer data from Bank 3. Managing projects These topics describe how to create projects and modify project properties.
As new customer data is added to the metadata repository, relationships can be discovered automatically and are linked to existing data records. Table-level specifications Provides the ability to define joins, filters and case statements, and use joins that are found during infos;here with IBM InfoSphere Information Analyzer.
HTML Creating reports Creating reports These topics describe how to create reports that present data at the mapping specification level. You can monitor recent activities of a mapping specification.
Then you can associate the metadata to a project and use the metadata to map source and target columns in a project. You can also delete metadata from the metadata repository. These actions are reflected in Figure 1. Importing metadata into the metadata repository You import metadata when you fastgrack to add metadata into the metadata repository for use in projects.
They also explain how to migrate from previous fasttrqck. Setting or checking status You can indicate the status of mapping specifications fastgrack specific source-to-target mappings by using the mapping editor. You can specify parameters within report templates so that you can obtain specific mapping specification information tailored to your requirements. In this module, you perform a join, add source columns based on lookup operators, and define business rules before you extract the customer information.
InfoSphere FastTrack information roadmap
Standardize customer name and address information and add a business term that defines a level of service. These lookup definitions are searchable and designed for reuse. The data is in one table: The standardized information is used to build information about platinum customers for the customer service department and information about gold customers for marketing. First Midwest created a standard customer database that its subsidiaries use to represent customer data.
Create mapping specifications that map data from the source to the target tables. With infodphere mapping editor, you create mappings by selecting source columns and target columns from data source tables. The application moves customer information from the bank subsidiaries into a standardized customer model.