Advanced ETL Processor: Introduction

In this tutorial, you will learn how to use Advanced ETL Processor to perform simple data transformation of a text file.

---

Closed Caption:

welcome to advanced ETL processor online
tutorial
we recommend watching this tutorial to
the users who are just starting working
with advanced ETL processor
this tutorial demonstrates basic
principles once you understand and you
will be able to work with any data
source
here we have mapping designer in the
middle you can see the data flow on the
right there is list of available objects
but impart shows US state of Florida
reader and data writer
we can also view the metadata
at the top we have a toolbar and four
tabs
data flow
she's usually hidden
rejected records and execution log
let us start from creating brand new
transformation
just click this button
default rate
nation
cases of data reader validator
transformer and data writer
data flows from the left to the right
let's create simple transformation it
will read a text file convert data and
see the result of transformation into
another file
let's check reader properties as you can
see our data source type is text file it
is delimited and file encoding is set to
auto delimiter is common header size is
one line
selecting source
Versailles
now we can see the data in the great
weekend reformat it manually or we can
use auto format function
we take field me
line
we are not going to
we just deleted
former
setting properties for the data rider
again target type is text
over
create
header file is delimited select the file
ok
fields data definition for data riders
should be exactly the same as for
datareader
we just copy it from the datareader
everything looks as it should be
we are now
ready to map the data
double-click on
former
on the left we have some
appeals on the right target field's
there are two ways we can join fields
here we can just drag-and-drop
drag it again to remove
or we can use on 20 map function which
is very useful when you have a lot of
fields
as you can see there are plenty of
options available to make the lives of
end user easier
we just click map now
ok everything is mapped
let's move our objects down so we have
more space
as you can see with the car
field there is slight problem we have
too many spaces so we have to remove
them
plus we would like to make first letter
of the company name uppercase
that can be easily achieved by using
transformations
we do have more than 500 of them
the one we need is called elite spaces
next
from we would like to use is called
first up
we just drag-and-drop
trip
one of the major benefit of using our
software that at any stage you can see
the result of transformation
we just press data preview
as you can see here we have
basis removed except one and first
letter of the company name is converted
to uppercase
week
don't move between different records and
see what is happening
or weekend
check the result of transformation by
clicking target dated have
ok
hey we are now
ready to transform our data
we just press wrong button
as you can see it took
transform the data
on the screen weekend see some messages
from the log
if you would like to see more
information just click Close and click
execution log tab
thank you for your time please visit our
website for more tips