Loading demo links...
What to study for each TDICDTS domain
Getting started with data integration
Introduces Talend Data Integration and the Talend Studio graphical user interface, including the Designer canvas, Repository and component Palette. It also covers creating a simple Job from components and connections.
Key skills
Talend Data Integration definition, Talend Studio GUI, Job Designer, Repository, Palette, creating a Job
Working with files
Covers configuring basic component properties, creating and configuring a schema, and reading delimited files into a Job. It also covers using the tMap component to configure a simple mapping and using pre-defined Talend Java functions in expressions.
Key skills
component properties, schemas, tFileInputDelimited, tMap, simple mappings, Talend Java functions, StringHandling, TalendDate
Joining and filtering data
Covers defining and configuring Talend metadata, joining two sources of data using the tMap component, and the tMap Join settings and reject capture mechanism. It also covers creating a filter condition in tMap and configuring a filter reject output along with multiple filtered outputs.
Key skills
Talend metadata, tMap joins, join settings, reject capture, tMap filters, filter reject output, multiple filtered outputs
Using context variables
Covers the standard context variable use case, defining context variables and contexts in the Repository, and using context variables in a Job. It also covers running Jobs in multiple contexts, such as development and production.
Key skills
context variables, contexts, context use cases, running in multiple contexts, context references in properties
Error handling
Covers using triggers such as OnSubjobOk and OnComponentError to create a sequence of subJobs and handle failures. It also covers using logging components such as tLogRow and tDie in a Job design, and creating If triggers based on component variables.
Key skills
triggers, OnSubjobOk, OnComponentError, logging components, tLogRow, tDie, If triggers, component global variables
Working with databases
Covers defining database metadata, setting actions on tables and data in database output components, and customizing SQL queries in database components. It also covers using metadata, generic schemas and context variables in database components.
Key skills
database metadata, actions on tables and data, customized SQL, generic schemas, context variables in database components
Orchestrating Jobs
Covers the typical master Job use case with tRunJob, the order of priority for passing parameters in context variables, and sending dynamic parameters to a child Job by overriding context variables. It also covers Joblets - explaining, refactoring, creating and incorporating them - parallelization options in Studio, and profiling Job execution with and without parallelism.
Key skills
master Jobs, tRunJob, context parameter precedence, dynamic parameters, Joblets, Joblet refactoring, parallelization, execution profiling
Deploying Jobs
Covers building a Job and understanding its build options, and running a standalone Job outside Talend Studio. It also covers handling context variables in standalone Jobs, configuring remote hosts in Studio, and launching a Job on a remote host.
Key skills
building Jobs, build options, standalone Jobs, context variables in standalone Jobs, remote hosts, remote launch
Project management
Covers the key differences between a local and remote connection and configuring a remote connection in Talend Studio. It also covers the key concepts of revision control with Git, performing operations on revision control, and defining a reference project and using items from a reference project.
Key skills
local connections, remote connections, Git revision control, version control operations, reference projects
Debugging
Covers debugging a Job using Traces Debug in Talend Studio, watching row flows on the Designer canvas during a run. It also covers stepping through and pausing a debug run and following individual rows to locate the component or expression at fault.
Key skills
Traces Debug, row flow inspection, stepping, pausing traces, locating faults