- Talend - Hive
- Talend - Working with Pig
- Talend - Map Reduce
- Hadoop Distributed File System
- Talend - Big Data
- Talend - Handling Job Execution
- Talend - Managing Jobs
- Talend - Context Variables
- Talend - Metadata
- Talend - Job Design
- Components for Data Integration
- Talend - Model Basics
- Talend - Data Integration
- Talend Open Studio
- Talend - Installation
- Talend - System Requirements
- Talend - Introduction
- Talend - Home
Talend Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Talend - Job Design
This is the technical implementation/graphical representation of the business model. In this design, one or more components are connected with each other to run a data integration process. Thus, when you drag and drop components in the design pane and connect then with connectors, a job design converts everything to code and creates a complete runnable program which forms the data flow.
Creating a Job
In the repository window, right cpck the Job Design and cpck Create Job.
![Creating Job](/talend/images/creating_job.jpg)
Provide the name, purpose and description of the job and cpck Finish.
![Description of Job](/talend/images/description_of_job.jpg)
You can see your job has been created under Job Design.
![Job Design](/talend/images/job_design.jpg)
Now, let us use this job to add components, connect and configure them. Here, we will take an excel file as an input and produce an excel file as an output with same data.
Adding Components to a Job
There are several components in the palette to choose. There is a search option also, in which you can enter the name of the component to select it.
![Palette](/talend/images/palette.jpg)
Since, here we are taking an excel file as an input, we will drag and drop tFileInputExcel component from the palette to the Designer window.
![Designer window](/talend/images/designer_window.jpg)
Now if you cpck anywhere on the designer window, a search box will appear. Find tLogRow and select it to bring it in the designer window.
![Search Box](/talend/images/search_box.jpg)
Finally, select tFileOutputExcel component from the palette and drag drop it in designer window.
![File Output Excel](/talend/images/file_output_excel.jpg)
Now, the adding of the components is done.
![New Job](/talend/images/new_job.jpg)
Connecting the Components
After adding components, you must connect them. Right cpck the first component tFileInputExcel and draw a Main pne to tLogRow as shown below.
![Connecting Components](/talend/images/connecting_components.jpg)
Similarly, right cpck tLogRow and draw a Main pne on tFileOutputExcel. Now, your components are connected.
![Components Conected](/talend/images/components_conected.jpg)
![Draw Main Line](/talend/images/draw_main_pne.jpg)
Configuring the components
After adding and connecting the components in the job, you need to configure them. For this, double cpck the first component tFileInputExcel to configure it. Give the path of your input file in File name/stream as shown below.
If your 1st row in the excel is having the column names, put 1 in the Header option.
![Header Option](/talend/images/header_option.jpg)
Cpck Edit schema and add the columns and its type according to your input excel file. Cpck Ok after adding the schema.
![Adding Schema](/talend/images/adding_schema.jpg)
Cpck Yes.
![Propagate](/talend/images/propagate.jpg)
In tLogRow component, cpck on sync columns and select the mode in which you want to generate the rows from your input. Here we have selected Basic mode with “,” as field separator.
![Progress Information](/talend/images/progress_information.jpg)
Finally, in tFileOutputExcel component, give the path of file name where you want to store
![Sync Columns](/talend/images/sync_columns.jpg)
your output excel file with the sheet name. Cpck on sync columns.
Executing the Job
Once you are done with adding, connecting and configuring your components, you are ready to execute your Talend job. Cpck Run button to begin the execution.
![Basic Run](/talend/images/basic_run.jpg)
![Log Row](/talend/images/log_row.jpg)
You will see the output in the basic mode with “,” separator.
![Basic Mode](/talend/images/basic_mode.jpg)
You can also see that your output is saved as an excel at the output path you mentioned.
![Output Path](/talend/images/output_path.jpg)