Features and Benefits
Features:
Easy-to-use import/export features allow business users to take advantage of familiar Microsoft® Excel® interface and create new specifications
Automates the creation of framework DataStage ETL jobs directly from business requirements with in-line instruction specific annotations
Customizable spreadsheet view enables annotation of column mappings with business rules and transformation logic including joins, lookups, data filters, and function logic
Define and reuse transformation rules across mapping specifications
Promote consistency across mapping projects with the ability to create templates
Generates custom reports in multiple formats
Apply naming standards for generated data definition language.
Provides a centralized location for tracking and auditing specifications for data integration projects
Create and link IBM InfoSphere Business Glossary terms and their relationship to corresponding physical columns as a part of the mapping and documentation process. InfoSphere FastTrack provides link to business glossary terms and has access to those terms when designing source to target or target-source mappings
Leverages active metadata to visualize mapping specifications for display in user interface.
Shared container support to enable reuse, consistency and standardized logic from mapping specifications for easy incorporation into InfoSphere DataStage jobs
Common connector support for DB2 and Oracle
Global enablement with translation for documentation and user interface in multiple international languages.
Benefits:
Improved strategic initiative project success rates. Helps to ensure that business requirements are consistently captured and are fully incorporated into technical solutions.
Faster time to value for business projects. Automating the supporting data integration processes enables speedy deployment. Coupled with Shared Container support this enables seamless insertion of standardized business logic from mapping specification into ETL jobs to help expedite job generation and bring consistency to data integration projects.
Ease of use promotes seamless incorporation and adoption of IBM Information Server FastTrack into business requirements processes.
Minimized risk of data misunderstandings. Defining and automating processes can eliminate errors that often cause re-work, missed project deadlines and overextended budgets.
Support for common exchange mechanisms. Aligns with corporate standards, policies and interface requirements.
Strengthened governance programs. Common web-based reporting supports auditing requirements from start to finish.
Enhanced collaboration. Align business analysts, developers and data architects by centrally storing business specifications and clearly documenting defined rules for consumption by each user role.
Productivity gains. Automatically translating business logic into code for developers helps save time and effort.
Improved data governance and auditing capabilities. IBM InfoSphere FastTrack provides a centralized, managed location for business and project requirements.
