Mapping Screen Overview

The transformation screen is used to create and modify data transformation processes.

The default transformation consists of a reader, validator, transformer and writer.

Screen Overview

Main tool bar

Main Tool bar

Main Tool bar

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

Transformation properties dialogue

  • 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

Transformation Properties

Template tab

The template shows the actual transformation script source.

Template Tab

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 analyze the activities of individual processes during their execution.

Execution Log Tab

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.

Rejected Records Tab

Working with objects

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.

Creating New Transformation and Working with Objects

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

joining two objects together

To remove the link, repeat the same procedure again.

Object popup menu options

Deleting Object

To change object properties double click on it.

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

Notes Dialogue

Notes Dialogue
Incremental Search

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

Incremental Search

Video Tutorials:

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

Confused? Ask question on our ETL Forum
Last updated: August 1, 2022