-
Before you begin: rebranding information
- Virtual Lab
-
How to Access a Remote Lab Environment.pdf
-
Videos and Lessons
DMX and DMX-h have been rebranded to be part of the new Connect family of products.
DMX is now known as Connect ETL and DMX-h is now Connect for Big Data.
-
Jobs and tasks 00:12:13
-
How to handle sources and targets 00:07:14
-
Data delimited files 00:20:30
-
LESSON_1_SETUP_JOBS_AND_TASKS.pdf
-
Transformation overview
-
How to define a copy 00:08:01
-
How to define a sort 00:07:32
-
How to define a reformat 00:16:51
-
How to define a filter 00:07:21
-
LESSON_2_REFORMAT_AND_FILTER.pdf
-
How to define a merge 00:04:49
-
How to define a partition 00:08:40
-
LESSON_3_SPLITTING_DATA_FOR_MAILINGS.pdf
-
How to define a join 00:09:01
-
Join task vs lookup function 00:02:41
-
How to define a lookup 00:12:00
-
LESSON_4_HOW_TO_DEFINE_A_JOIN.pdf
-
How to define an aggregate 00:13:28
-
LESSON_5_HOW_TO_DEFINE_AN_AGGREGATE.pdf
-
How to run jobs 00:18:00
-
LESSON_6_HOW_TO_DEFINE_MAINFRAME_DATA_AS_SOURCE.pdf
Connect ETL: The Basics
This hands-on workshop introduces participants to Connect ETL features including how to build and run data integration jobs that read and write data to/from a variety of data stores
This 6 hour, online, hands-on workshop introduces participants to the basic features of Connect ETL (Formerly known as DMX) and is intended for customers that have purchased Connect ETL. Participants are presented with the key benefits and will learn how to handle various data sources such as fixed length and delimited files.
Participants will learn how to create jobs as well as tasks using transformations such as copy, sort, join, merge, aggregate, reformat, filter and partition. Participants will also learn how to deploy the jobs that they have developed.