Talend Training Course Details

             Talend Course Details

Data Warehousing Introduction

·         Overview of the concept of Data Warehouse.

·         Dimensions, Hierarchy, Facts

·         DW models:- Star and Snowflake schemas.

·         Introduction to Talend

·         Talend Data Integration Overview

Talend Introduction

·         Talend Environment – 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 schenaios 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 Enviromnet

·         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.

*I will also provide Talend job support.

*And also I will provide free demo session. Please call me on below number.

Thanks,

Raja K

+91 9247360004

Load OracleDatabase Table data From Filedata

 Load Database table  from CSV files that contains the following fields:

•          Employeid 
•          Employename
•        Dateofjoin
•         Salary

                                  

The file would looks like this:

 

We want to load this file into a OracleDatabaseTable  with a schema as follows:

 Here are the steps we will take to build our Talend Open Studio solution:

Step 1:  Open Talend

Open Talend and create or open an existing project

Step 2: Create a new job

Right click on Job Designs in the Repository window and select “Create job”

Name the job “item_load”

    Enter the name of JOb

Step 3: Create a File Delimited repository element

Now we need to create a repository item for our  Oracle databaseTable. To do this click the arrow next to “Metadata”  in the Repository window and right click on “File delimited” and select “Create file delimited”

Enter a name for your example file schema and click next:

.

 

Select your example file that we saw earlier (or use your own) by clicking the “Browse” button.

Click Next

 

 

On the next screen select field separator as comma (as per your file data) and select the checkbox for “Set heading row as column names”, then click “Refresh Preview”. Click Next.

Talend has now generated an estimated schema, review this schema and make any changes as you would like, then click Finish.

Step 5:  Design your job

In this step we are going to design our job to connect our CSV file to our OracleDatabaseTable.

Open the job we created in Step 2 by double clicking the name of the job under Job Designs in the Repository window.

In the palette window on the right hand side type “tFileinputDelimited” into the search box, then drag and drop the component “tFileInputDelimited” into the job window in the center of the screen

  Select the tFileInputDelimited Component in the job window and then select the “Component” tab near the bottom middle of the screen.

Click the drop down box next to “Property type” and select “Repository”

Then click the button with three dots that appears and select the delimited file from the repository that we created in Step 3.

Select a tMap component from the palette on the right hand side of the screen and drag it into the job design window

 Right click on the tFileinputDelimited component, select Row->Main and connect a row to the tMap component.

 

 

Select a tOracleoutput  component from the Palette and drag it over to the job design window.

                                         

Click on the tOracleoutput  component to select it, then navigate to the Component tab in the lower middle of the screen. Fill all blocks

Connection Type:

DB Version:             

Host:

Port:

Database:

Oracle schema:

Username:

Password:

Action on Table: 

Next right click the tMap component, Select “Row” then “New Output”.

Connect this new output to the tOracleoutput component

Name the output row- “output1″

Now your tMap is connected to the tOracleoutput component, double click the tMap component to open up the tMap editor.

Click and drag the data fields from the “row1″ panel to the left of the screen to the corresponding “output1″ data fields. This tMap editor enables you to map to fields from the CSV input to the correct output fields in tOracleoutput data fields.

Click “Apply” then “OK” to save the changes and return to the Job Design window

Now your job design is complete and we just need to run the job to load the file into OracleDatabaseTable.

  

Step 6: Run your Job

In the group of tabs in the lower middle of the screen, select the “Run” tab

 

Under Execution, click the “Run” button

Your job will load and then run and you will see how many rows were processed in the job design window

Congratulations! You have now loaded your one file into your OracledatabaseTable.