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):||7 December 2008|
|PDF File Size:||19.52 Mb|
|ePub File Size:||17.89 Mb|
|Price:||Free* [*Free Regsitration Required]|
Scenario for mapping data
As new customer data is added to the metadata repository, relationships can be discovered automatically and are linked to existing data records. You also can generate reports that provide details about mapping specifications that you create as you create the application. You can also manage projects and change your server password. The business analysts can also use InfoSphere FastTrack to discover and optimize mapping by using existing data profiling results from the metadata repository.
Scenario for mapping data
Bank 2 also keeps track of demographic data about customers in a separate table, BANK2. Import data from Microsoft Excel spreadsheets and.
You can also export mapping specifications into Microsoft Excel spreadsheets and. The standardized information is used to build information about platinum customers for the customer service department and information about gold customers for marketing. The issues documented in this section provide descriptions of the problems and steps to correct them.
A closer look at 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.
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.
Creating reports These topics describe how to create reports that present data at the mapping specification level. Standardize information, use business terms, and create data extractions for customer marketing and knfosphere In this module, you associate customer data with business ifosphere and create data extractions for marketing and customer service.
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. Relationships with InfoSphere Business Glossary terms Helps you to create new business terms and document their relationship to corresponding physical columns as a part of the mapping process. Importing mapping specifications These topics describe how to import mapping fasttarck from other application sources, modify the fadttrack specifications in InfoSphere FastTrackand then export the mapping specifications so that you can share your specifications with other team members.
Modules in this tutorial Module 1: 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.
By using InfoSphere Information Serverthe Fxsttrack team consolidated the business category and category fasrtrack, customer metadata such as account balance and credit history data fieldsand multiple data models in the metadata repository.
By using InfoSphere Innfospherethe Fasttraack team specified data relationships and transformations that the business analysts used to create specifications, which consist of source-to-target mappings.
Message reference These topics describe warning and validation messages, explain why they occur, and recommend actions to take. InfoSphere FastTrack accelerates the design time to create source-to-target mappings and to automatically generate jobs. HTML Creating mapping specifications These topics describe how to create mapping specifications that consist of source-to-target mappings, and how to use imported InfoSphere DataStage shared containers as mapping components.
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. 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.
Identify gold customers as level B and platinum customers as level A. First Midwest wants to ensure that gold customers are offered new investment opportunities and that platinum customers are given premium customer service when they call in with issues.
A financial institution recently acquired several companies. Reports You can create reports that you can distribute to authorized users. 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.
Tutorial: IBM InfoSphere FastTrack Facilitated mapping creation
fastgrack The specifications link the customer data fields to key business terms and transformation rules that are used to compute new data fields. You can also view detailed properties information including an expandable view of the artifacts in the IBM InfoSphere Information Server metadata services repository.
Customizable spreadsheet view Provides the ability to annotate column mappings with business rules and transformation logic.
Flexible reporting capabilities Provides information on column-level mappings, table-level mappings and lookups. Move gold customer data appropriate for marketing such as name, address, and gender from the bankdemo. 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.
Customers might have checking and savings infospherr.