Advanced ETL Processor: Using Transformer Object

Advanced ETL Processor has more than 500 data transformations and validation functions

This simple tutorial demonstrates principles of working with data transformer.

---

Closed Caption:

welcome to advanced ETL processor online
tutorial
this presentation explains how to work
with transformer object
here we have very simple transformation
on the right we have a list of available
objects
let's
former object and Lincoln
double click to open it
on the left we have a list of source
fields
on the right target field's
list of
appeals is taken from previous object
when transformer is connected to data
writer list of target field's is taken
from it
when transformer is connected to
something else
list of target field's is defined inside
transformer
we will demonstrate it later
to avoid problems always make sure that
last object before data rider is a
transformer
ok
let's create a simple transformation
designing transformations is easy
just use drugs and drop to link the
objects
and repeated to remove the link
we are constantly working on making the
life of the end users easier
on the map function is here to save your
time
just one click and everything is mapped
on the right you can see a list of
supported transformation functions
there are about 500 of them and this
number is constantly growing
let's say for example we want to convert
month name to uppercase
type upper
here is our function
drug
drop it
Lincoln
John
another
saver is processed data button
it allows to see the result of
transformation without actually running
it
here it is
it is also possible to enter the data
for testing
hugs
another useful feature
splitting the train
nation using tabs
it is here to make designing large and
complex transformations easier
let's call it
do
here is our test
let's move some
up to
let's deleted we have to move
lost
Tab 2 is deleted
let's delete existing transformer and
add
to transformers
link them
as you can see
missing target field's as explained
earlier this is because it is not
connected to the writer
this is normal
we can add fields one by one or we can
copy fields
it is also possible to rename fields
here
and of tutorial
thank you for your time
time please visit our website for more
information