About Course

The course aims at providing an in-depth training on Talend Data Integration tool with exposure to various Data Integration scenarios. It is an instructor led course with numerous live examples and hands on sessions.

Trainer's Information

Trainer is a Talend Certified Designer with 10+ years of experience in the Data Warehousing domain and has worked on various end to end data warehousing implementations. Trainer has conducted numerous training sessions on various DW aspects and technologies.

Prerequisites

Basic knowledge in computing, SQL or other general concepts of databases.

Talend Data Integration

  • Introduction to Talend

    • Pre-requisites
  • Tool Overview

    • Repository
    • Job Window
    • Palette Window
    • Component Window
  • Creating Talend Jobs

    • Input Components
    • Output Components
    • Component Links

      • 1. Main
      • 2. Reject
    • Sub Job /Component Links

      • 1. On Subjob Ok/error
      • 2. On Component Ok/Reject
      • 3. Iterate
    • Conditional Executions with RunIf
    • Important Transformations

      • 1. Tmap

        • 1. As Filter
        • 2. As Router
        • 3. As Expression
        • 4. As Lookup
      • 2. Tlogrow
      • 3. TlogCatcher
      • 4. Connection Components
    • Working with Context Variables

      • 1. Local Context Variables
      • 2. Context Groups
      • 3. Creating Different Views in Context Group.
    • Working with Joblets
  • Job executions

    • Run time properties

Introduction to Talend Enterprise Edition

  • Architecture
  • Remote Execution from Studio
  • Parallel Execution
  • Introduction to Talend Administrator
  • Scheduling Jobs through Talend Administrator

Excercises

  • Test 1: Create a Talend Studio Job which reads from a flat file and loads data into another file. Do not hardcode the file path and delimiter.
  • Test 2: Create a Talend Job which loads a delimited flat file into a My SQL staging table.
  • Test 3: Create a Talend Job to demonstrate SCD type 1
  • Test 4: Create a Talend Job to demonstrate SCD type 2

TALEND DQ

  • Overview
  • Data Profiling
  • Applications of Data Profiling
  • Getting started with Talend Data Quality
  • Working with Flat Files
  • Working with Relational Databases
  • Simple Column Analysis
  • Pattern Analysis
  • Creating Custom Patterns
  • Creating Correlated Analysis
  • Analyze Matches

Leave your feedback