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):||19 July 2015|
|PDF File Size:||1.16 Mb|
|ePub File Size:||3.23 Mb|
|Price:||Free* [*Free Regsitration Required]|
You then use the data source to create source-to-target mappings. Within a specification, you can obtain statistics, such as the percentage of column mappings that have the onfosphere and target mapped, the number of source and target tables, and the types of transformations in a mapping specification.
Troubleshooting These topics describe log files, administrative tools, and how to troubleshoot issues such ijfosphere problems with authentication and configuration. BANK 3 Holds only savings accounts.
You then integrate the customer data from the BANK 3 subsidiary into the database containing the standardized customer information. You can also manage projects and change your server password. 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.
Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation
System requirements The following components and applications must be installed on your system. HTML Working with mapping 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.
Working with mapping specifications. The remaining modules each take about infoephere to complete. HTML Tutorial These topics present a tutorial that show how to create an application that identifies customers with high value to your business.
These tasks are required to build the application that identifies high-value customers:: First Midwest subsidiaries and the plan for how the data flows.
IBM InfoSphere FastTrack
Standardize information, use business terms, and create data extractions for customer marketing and service In this module, you associate customer data with business terms and create data extractions for marketing and customer service.
Creating mapping specifications You create mapping specifications that consists of source-to-target mappings. Then you can associate the metadata to a project and use the metadata to map source and target columns in a project. Learning objectives By completing the ifosphere, you will learn about these functions: 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.
Reports You can create reports that you can distribute to authorized users. Bank 2 also keeps track of demographic data about customers in a separate table, BANK2.
Customers might have checking and savings accounts. These customers were neglected or not treated preferably at First Midwest. The following steps illustrate the sequence of actions: 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. HTML Administration These topics describe how to perform general administration tasks, such as setting up user security, managing sessions, reviewing logs, scheduling activities, and managing assets.
With the job generation faxttrack, you can generate multiple specifications into a single job. Identify gold customers as level B and platinum customers as level A.
Job generation automatically derives an extract, transform, and load flow from business requirements. First Midwest defines two levels of high-value customers.
IBM InfoSphere FastTrack
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. BANK 1 Holds only checking accounts.
HTML Creating reports Creating reports These topics describe how to create reports that present data at the mapping specification level. You also can generate reports that provide details about mapping specifications that you create as you create the application. 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.
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.
Generate jobs that are used to build applications Generate reports to view mapping specifications statistics and characteristics. Set up the tutorial environment You must prepare your system to run the tutorial.
You can also delete metadata from the metadata repository. The following components and applications must be installed on your system. For this tutorial, you will follow a fictional scenario about the First Midwest company. By linking information in a shared metadata repository, data is accessible, current, and integrated across the data integration project. Move gold customer data appropriate for marketing such as name, address, and gender from the bankdemo.
A financial institution recently acquired several companies.
Creating specifications A financial institution recently acquired several companies. InfoSphere FastTrack assets You can use the -fasttrack option of the istool command in a command-line interface to move InfoSphere FastTrack projects fashtrack related assets across different installations of InfoSphere Information Server.
Users can track and automate multiple data integration tasks, shortening the time between developing business requirements and implementing a solution. BANK 2 Holds checking and savings accounts. You will experience how InfoSphere FastTrack increases the ease and efficiency by which fasttraci create mapping specifications.
A closer look at InfoSphere FastTrack
The relationships are then published to the InfoSphere Information Server metadata services common repository so that they can be shared across development teams.
You can compose jobs that are parallel or sequential. These lookup definitions onfosphere searchable and designed for reuse. Imported metadata is viewable by all suite users and can be used by all suite components.