Module 1: Getting Started With Talend Open Studio
- Studio Definitions e Starting the studio
- Creating the project
- Everything about Talend GUI e Creating an example job
Module 2: Working With Metadata
- Creating a Built-in Schema
- Creating Repository Schema
- Propagating Schema Changes
- Dropping Schema to empty components
- Cutting and pasting schema information
Module 3: Working With Files Reading Delimited files
- Reading Positional Files
- Reading Excel Files
- Reading XML Files
- Reading Regex files
Module 4: Usage Of Database Components In Talend tOracleConnection
- tOraclelnput tOracleOutput tOracleRow
Module 5: Using tMaps
- Overview of tMap
- Connecting multiple inputs to tMap
- Creating joins in tMap
- Catching Rejects in tMap
- Using Expression Builder in tMap e Using Variable In tMap
- Performance Tuning of Look Ups In tMap
Module 6: Using of Processing Components in Talend tJoin
- tFilterRow
- tAggregateRow tSortRow
- tReplace
- tAggregateSortedRow
- tNormalize
- tDeNormalize
Module 7: Basics Of Java Classes and Objects
- Writing Hello Java Program
- OOPS Concepts © Method Overloading o Static Keyword
- Abstract Modifiers
- Handling Java String
Module 8: Using Java In talend Creating Routines in Talend
- Using Custom Code in Talend
- Using tJava component
- Using tJavaRow component
- Using tlavaFlex component
Module 9: Using of Iterative And Data Quality Components In talend tFileList
- tFlowtolterate tlteratetoFlow tUnigRow
- tReplacelist
- tSchemaComplianceCheck
Module 10: Configuring Statistics and Logs in Talend
- Capturing Statistics at Project Level
- Using tWarn, tDie, tFlowMeter
- Using tFlowMeterCatcher, tLogcatcher Using Global Variables in Talend
Module 11: Preparing For Deployment
- Creating Context variables
- Creating Context group
- Usage of Prompts in Talend Jobs Running Jobs in different contexts Using tContextLoad
- Using tContextDump
Module 12: Creating Subjobs Using tRunlob
- Passing parameters to Sub Job
- Passing context variables from Parent Job to Child Job Passing context variables from Child Job to Parent Job
Module 13: Data warehousing basics
- Data warehousing Architecture Dimension Tables
- Fact Tables
- Types of Schema
- Slow Changing Dimension
- OLAP and OLTP
Module 14: Using SCD Components in Talend
- Using SCD Type 1 Components Using SCD Type 2 Components
- Using SCD Type 3 Components
- Module 15: Working With Metadata
- Export and Import Talend Jobs/Projects
- Running Talend Job using Windows Task Scheduler
- Performance Tuning in tMap
- Performance Tuning using Subjobs
- Using ETL Components
Module 16: Case Study/Project-Building a retail Data Warehouse
- Discussing Business Requirements Document
- Creating Staging Load Jobs
- Creating Dimension Load Jobs Creating Fact Load Jobs
Module 16: Case Study/Project-Building a retail Data Warehouse Discussing Business Requirements Document
- Creating Staging Load Jobs
- Creating Dimension Load Jobs Creating Fact Load Jobs
Module 17: Designing a Business Data Models in Talend
- Opening/Creating a Business Model Modelling a Business Model
- Assigning Repository elements to a Business Model