Talented Open Studio

  • Basics of ETL
  • Data warehouse Concept
  • Database Concept
  • What is ETL?
  • Where ETL will use?
  • Talend Studio Basics
  • Introduction to Talend Open Studio
  • Scope of Open Source Tool
  • Start Talend Open Studio for Data Integration
  • Link Talend Studio to your Talend account, registering a new account if necessary
  • Talend Studio Advance (Integrator) – Part 1
  • Starting Talend Open Studio
  • Create a Talend project to contain tasks
  • Create a Talend Job to perform a specific task
  • Reading Input
  • Transforming Data
  • Running a Job
  • Add and configure components to handle data input, data transformation, and data output
  • Run a Talend Job and examine the results
  • Build a visual model of a Talend Job or project
  • Copy an existing Job as the basis for a new Job
  • Store configuration information centrally for use in multiple components
  • Extend data from one source with data extracted from a second source
  • Log data rows in the console rather than storing them
  • Troubleshoot a join by examining failed lookups
  • Use components to filter data
  • Generate sample data rows
  • Execute Job sections conditionally
  • Duplicate output flows
  • Create a schema for use in multiple components
  • Create variables for component configuration parameters
  • Run a Job to access specific values for the variables
  • Employ mechanisms to kill a Job under specific circumstances
  • Include Job elements that change the behavior based on the success or failure of individual components or subjobs
  • Connect to a database from a Talend Job
  • Use a component to create a database table
  • Write to and read from a database table from a Talend Job
  • Filter unique data rows
  • Perform aggregate calculations on rows
  • Write data to an XML file from a Talend Job
  • Use components to create an archive and delete files
  • Use a Talend component to access a Web Service method
  • Extract specific elements from a Web Service reply
  • Store Web Service access information for use in multiple Jobs
  • Write an XML document to a file
  • Add comments to document a Job and its components
  • Generate HTML documentation for a Job
  • Export a Job
  • Run an exported Job independently of Talend Open Studio
  • Create a new version of an existing Job
  • Exporting a Job

Duration :  25hours