Mapping Screen Overview

In order to load data from the data source into the data target, you must define data mapping between the data source and the data target. The typical transformation consists of a reader, transformer and writer.

The data processing screen provides a number of settings, for the three stages of reading, transformation and writing. This is facilitated by the main toolbar and a list of available objects. The main reader toolbar provides the user with all the necessary functionality to setup the reading process, according to the settings provided.

The main toolbar provides a number of icons that allow the user to create the steps required to carry out the automatic functions required.

1. Transformation Properties
2. New Transformation
3. Load Transformation From the file
4. Saves Transformation to the file
5. Saves Transformation under the new name
6. Saves Transformation to the Repository
7. Cut
8. Copy
9. Paste
10. Delete
11. Undo
12. Redo
13. Align Left
14. Arrange Vertically
15. Align Right
16. Align Bottom
17. Arrange Horizontally
18. Align Top
19. Space Horizontally
20. Space Vertically
21. Snap to grid/show grid
22. Prints Transformation
23. Print Preview Transformation
24. Search Objects
25. Manage Versions
26. Add Version
27. Revert to the previous version
28. Make Transformation Read Only
29. Process Data
30. Schedule for Execution
31. View Execution Log (When executed within the package or by agent/scheduler)
32. Zoom In
33. Zoom Out
34. Zoom 100%

The incremental search dialogue provides a convenient way of locating transformation objects to the end-user within complex data mappings.

Click to change Transformation properties.

• Default Date format applies to all templates.
• It is used for new Date related validation and transformation functions such as Is Date, Is Date between ETC

The template shows the actual transformation script source.

By default template tab is hidden, it can be enabled by using options dialogue

The execution log provides information about the Advanced ETL Processor and the actions it took during its operations. This is useful when you wish to analyse the activities of individual processes during their execution.

Logging takes time, it can be disabled using options dialogue

Occasionally, records will be rejected by the processor. This may be due to things like corrupt records which have been read in a format not expected by the processor. The rejected records tab allows the user to see a list of all the rejected records and other information about the nature of the rejection and where this occurred in the process.

To create new transformation Click . The new transformation consists of Reader, Validator, Transformer and Writer. You may add a new object at any time by dragging it from the Objects panel.

To join two objects together, first click on the source Output button then drag it on to the Input button.

To remove the link, repeat the same procedure again.

Object popup menu options.

To change object properties double click on it.

Automatic Version Control

Every time the user presses the save button transformation is automatically added to the version control