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.

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

Template tab

The template shows the actual transformation script source.

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.

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.

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.

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

Automatic Version Control

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

Notes Dialogue

Incremental search

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

Video Tutorials: