Mapping Screen Overview

In order to load data from the data source into the data target you must define data mapping between data source and data target. Typical transformation consists of 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 tool bar, 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.

Main Tool bar

The main tool bar provides a number of icons which 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 dialog 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

Template Tab

The template shows the actual transformation script source.

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

Execution Log Tab

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

Rejected Records Tab

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 . New transformation consists of Reader, Validator, Transformer and Writer. You may add 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 save button transformation is automatically added to the version control

Video Tutorial

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetl/processing_data/screen_overview.txt
  • Last modified: 12/07/2015 18:13
  • by admin