I was planning to write a blog combining all the pieces that I have been describing in my previous blogs. But one of my colleague reminded me to blog on FastTrack and so here is something on InfoSphere FastTrack.
A DataStage developer works on a business requirement. And how can a Business Analyst give the developer a business requirement and that too in a way in which the developer can quickly use it. IBM InfoSphere FastTrack streamlines collaboration between business analysts, data modelers, and developers by capturing and defining business requirements in a common, familiar format and then transforming that business logic directly into DataStage ETL jobs.
The completed mapping specification can be output in several formats, including an annotated InfoSphere DataStage job that is generated directly by InfoSphere FastTrack. This format is useful for the InfoSphere DataStage developer because the specification is delivered in a manner in which the developer is familiar. In addition, this delivery format provides a job template that can be used as the basis for creating a job, including design artifacts that can be copied to the new job as is.
As shown in the figure below, the use of InfoSphere FastTrack for mapping specification documentation includes the following advantages:
- Centrally stored and managed specifications
- Simple drag-and-drop functionality for specifying source and target columns
- Accuracy of source and target column names (that exist in the repository) with assured correct spelling
- Discovery of mappings, joins, and lookups assistance, based on published data profiling results, name recognition, and business-term assignment