Defining transformation specifications and loading instructions is quick and easy. When moving data into dependent database systems, one of the most difficult activities is defining transformation rules. Pursuit provides a unique simulation interface that allows users to display and test transformations using actual data during every stage of the design process. This simplified user interface is a real timesaver in development environments, providing the opportunity to test transformations without impacting production systems. Data can be viewed in the source systems, transformation calculations, look-up tables, rejection calculations and target tables.
Pursuit provides live data simulation for every step of the transformation process.
Hundreds of predefined functions are available, including aggregations, looping logic, table look-ups and string manipulations. The Debugger feature provides an important level of comfort and increase in speed of development for users. The Debugger scans procedure syntax, notifies users of syntax errors and automatically adds required elements where possible. Transformations can also be triggered by events or based on preceding transformations, allowing staged transformation of data. Schedules include calendar dates, arbitrary time periods and holidays.