Introduction to Data Warehousing
· Data Warehouse Overview
· Facts,
· DW
models:- Star and Snowflake schemas.
· Talend Introduction
· Introduction to Talend
· Talend Data Integration Overview
· Talend
installation
· Starting
Talend job design and development
· Repository,
Designer and Palette
· Talend
Design
Talend Jobs
Designing
· Types
of Components
· Basic
Components - Overview
· Component
Properties
· Database
connectivity components
· Triggers
in Talend
· Sample
Job designing
· Job
Execution
· Usage
of tMap component and other important components from all sections like
Processing, Orchestration, File, database etc.
· Exercises
for job development (hands on training)
· How
to Capture information about job execution
· How
to create a table to store monitoring information
· Detailed
Log Generation:
· Number
of records inserted/ updated/ rejected. In case of failure, details of the
failed records.
· Exercises
for job development (hands on training)
· Optimization
for running the job
Talend Context and
Variables
· Context
Variables - Overview
· Creation
and Usage of Context Variables and Context Groups
· Dynamic
Job designs using Context variables
· Making
database connectivity parameters as job contexts
· Configuring
the job to run it on remote machine
· Bulk
Insert/ Update
· How
to execute the jobs remotely
· Command
line utility and basic and advanced commands
· How
to clean enhance data and reference data
· How
to migrate jobs from DEV to TESTING to PROD environment
· Case
study and hands on development training on the required jobs
Metadata in
Talend.
· Built-in
Connections
· Shared
Connections
· Source
and Destination Connections
· Database
Connections
· Usage
of connections in Job
Logs & Error
· Logs
and execution statistics in Talend
· Error
Handling in Talend
· Logs
& Error Handling Components
· In
case of notification failure Email generation
· Optimization
for running the job
Exercises
· Real
time scenarios on all discussed components
· Optimization
for running the job
· How
to migrate jobs from DEV to TESTING to PROD environment
· Case
study and hands on development training on the required jobs
· How
to run jobs in Linux Environment
· How
to integrate talend jobs with java.
*And
also provides resume preparation.
*After this training you can handle any Data Integration (ETL) or Migration projects independently.
Thanks,
Sharad
mobile - +91- 9731059957
Email :- talendetltraning@gmail.com