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 2005|
|PDF File Size:||5.51 Mb|
|ePub File Size:||16.67 Mb|
|Price:||Free* [*Free Regsitration Required]|
You can also save the job in the metadata repository. The remaining modules each take about minutes to complete. You can fasttrafk parameters within report templates so that you can obtain specific mapping specification information tailored to your requirements.
First Midwest subsidiaries and the plan for how the data flows. Troubleshooting These topics describe log files, administrative tools, and how to troubleshoot issues such as problems with authentication and configuration.
Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation
With the job generation wizard, you can generate multiple specifications into a single job. A financial institution recently acquired several companies.
InfoSphere FastTrack offers the following capabilities: 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 to complete tasks, and directs you to information about how to complete configuration tasks. First Midwest wants to ensure that gold customers are offered new investment opportunities and that platinum customers are given premium customer ifnosphere when they call in with issues.
Bank 2 also keeps track of demographic data about customers in a separate table, BANK2.
Then you can associate the metadata to a project and use the metadata to map source and target columns in a project. The relationships are then published to the InfoSphere Information Server metadata services common repository so that they can fsattrack shared across development teams. You can also export mapping specifications into Microsoft Excel spreadsheets and.
InfoSphere FastTrack capabilities
Generating jobs These topics describe how to generate jobs from mapping specifications. You can also create candidate columns and terms within specifications.
Components in the suite. Therefore, account balances for both checking and savings accounts must be aggregated to compute the total account balance for a customer. 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. Working with mapping specifications.
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. BANK 3 Holds only savings accounts. Creating specifications A financial institution recently acquired several companies. First Midwest is a financial institution that grew by acquisition. You then integrate the customer data from the BANK 3 subsidiary into the database containing the standardized customer information.
Scenario for mapping data
The business analysts worked extra hours creating source-to-target mappings by manually creating specifications that map customer data across multiple targets. You can obtain additional data from columns for your mapping specification by using lookup tables. Now you must integrate the customer data from Bank 3. HTML Tutorial These topics present a tutorial that show how to create an application that identifies customers with high value to your business. 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.
First Midwest created a standard customer database that its subsidiaries use to represent customer data. System requirements The following components and applications must be installed on your system.
Users can track and automate multiple data integration tasks, shortening the time between developing business requirements and implementing a solution. Setting or checking status You can indicate the status of mapping specifications and specific source-to-target mappings by using the mapping editor.
In this module, you perform a join, add source columns based on lookup operators, and define business rules before you extract the customer information. You then use the data source to create source-to-target mappings.
Introduction to IBM InfoSphere FastTrack
First Midwest defines two levels of high-value customers. Standardize information, fasttradk 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.
You can monitor recent activities of a mapping specification. The business analysts can also use InfoSphere FastTrack to discover and optimize mapping by using existing data profiling results from the metadata repository. Identify gold customers as level B and platinum customers as level A.
First Midwest has these subsidiaries: 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 also can generate reports that provide details about mapping specifications that you create as you create the application.
The need for speed – accelerating data integration projects This white paper explains how InfoSphere FastTrack can help enterprises accelerate the deployment of data integration projects by simplifying and improving the communication process between the business analyst and the developer. In Module 1, you prepare for the tutorial.
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. Import data from Microsoft Excel spreadsheets and. As new customer data is added to the metadata repository, relationships can be discovered automatically and are linked to existing data records.
The standardized information is used to build information about platinum customers for the customer service department and information about gold customers for marketing. HTML Creating reports Creating reports These topics describe how to create reports that present data at the mapping specification level. By using InfoSphere Information Serverthe IT team inrosphere the business category and infospherd terms, customer metadata such as account balance and credit history data fieldsand multiple data models in the metadata repository.