|
Business Intelligence Training Overview
Talend Open Studio for Data Integration dramatically improves the efficiency of data integration job design through an easy-to-use graphical development environment. It enables rapid deployment and reduces maintenance costs with prebuilt connectors to all source and target systems, with support for all types of data integration, data migration, and data synchronization operations.
This course enables you to use Talend Open Studio for Data Integration for real work as quickly as possible. It focuses on the basic functionality of the Studio and how it can be used to build reliable, maintainable data integration tasks that solve practical problems: extracting data from common database and file formats, transforming it, and integrating it into targets. The skills learned in this course are applicable to the entire Talend product line. This course serves as the basis for all Talend training and is the prerequisite for many of the other courses.
What you will learn
- Start Talend Open Studio for Data Integration
- Create a Talend project to contain tasks
- Create a Talend Job to perform a specific task
- Add and configure components to handle data input, data transformation, and data output
- Run a Talend Job and examine the results
- Extend data from one source with data extracted from a second source
- Log data rows in the console rather than storing them
- Execute Job sections conditionally
- Duplicate output flows
- Create variables for component configuration parameters
- 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
- Export a Job
- Run an exported Job independently of Talend Open Studio
- Create a new version of an existing Job
Business Intelligence Audience
Developers with any RDBMS Applications
Business Intelligence Prerequisites
- All the participants must be aware of any RDBMS activities along with its application.
- Data Warehousing Basics Knowledge.
- Prior Experience of any Talend Versions not required.
.
Business Intelligence Training Course duration
Five(5) Days Classroom & Lab Session(50% Lecture & 50% Hands-on Labs).
Two(2) Days Basics
Three(3) Days Advance
Business Intelligence Training Course outline
Day 1 & 2
- Starting Talend Open Studio
- Creating a Job
- Reading Input
- Transforming Data
- Running a Job
- Combining Columns
- Building a Business Model
- Duplicating a Job
- Creating Metadata
- Creating a Join
- Capturing Join Failures
- Correcting the Lookup
- Updating the Business Model
- Generating Rows
- Creating the Join
- Adding Constraints
- Replicating Output
- Using Context Variables
- Using Repository Context Variables
- Handling Errors
Day 3, 4 & 5
- Working with Databases
- Creating a New Project
- Creating Customer Metadata
- Creating the Customer Table
- Creating the Product Table
- Setting up Sales Files
- Setting Up the Shop Staging Table
- Joining the Data
- Finalizing the Job
- Documenting the Job
- Running Jobs Standalone
- Exporting a Job
|
