Talend Installation on Windows with Pictures




First, we need Prerequisites for Installation of Talend in the Windows operating system.

Prerequisites for Talend Installation:

While Talend installation memory usage heavily depends on the size and nature of your Talend projects. If your jobs include so much of transformations components you should be upgrading the total amount of memory allocated to your servers.

Based on the following recommendations for Talend installation:

Product - Studio
Client/Server - Client
Memory - 4GB recommended
Disk space installation - 6 GB

Before installing of Talend we need to configure the JAVA_HOME environment variable so that it points to the JDK directory.



Example:C:\Program Files\Java\jdk1.x.x_x\bin

Simple Steps to Talend Installation:

After completion of the above steps then download Talend studio files like Data Integration, Big Data, and cloud trail version:

Talend Studio Download

Step 1: Goto Talend official website for Talend studio zip file contains binaries for All platforms (Windows/Mac).

Once the download is complete, extract the zip file on your Windows operating system.

Step 2: We get the Talend folder then double click on the TOS_DI_win_x86_64.exe. And executable file to launch your Talend studio like below image.

You need to recommend more memory and space to avoid spaces in the target installation directory.

Step 3: After clicking on Talend icon then ‘accept’ the user license agreement.

Step4: After Accepted the agreement then starts your journey with Talend studio. For the first time user, need to set up a new project or you can also import a demo project and click the Finish button.

 

After successful completion of Talend Studio Data Integration installation on windows. To open a welcome window and launch the studio simply.

Talend studio requires different types of libraries like Java (.jar) files and database drivers to be installed to connect a source to target.



These libraries are also known as external modules in Talend studio. If you want a cloud trail version or Big Data version for more features then simply installed it.

Sample Talend Questions – MCQs



1. Which of the following in the design workspace indicates an error with a component in Talend

A) A red ‘X’                                                                      B) A red exclamation point

C)A green ‘ I’                                                                    D)A yellow  exclamation point

2. Which of the following components can be used to implement lookup in Talend

A)tJoin                                                                         B) tLookUp

C)tMap                                                                        D)tUnite

3.tMap offers following match modes for a lookup in Talend studio

A)Unique match                                             B)Only unique match

C)First match                                                   D)All matches

4.tMap offers following join model in Talend tool

A)Left Outer Join                                     B)Right Outer Join

C)Inner Join                                                D)Full Outer Join

5. Which of the following the components is used to execute a job infinite times in Talend

A)tInfiniteLoop                                          B) tFileWatcher

C) tForEach                                                  D)tRunJon



6.How to access parameters in the Global Map in Talend ETL tool

A)globalMap.put(“Key”, Object)

B)globalMap.get(“Key”, Object)

C)globalMap.put(“key”)

D)globalMap.get(“key”)

7. How do you reference the value of Context Variable FileName in configuration while Talend programming

A)Context.FileName                                B)context.FileName

C)FileName.value                                     D)$context.FileName

8. While Installing your Talend solutions, you have to set the following variable is mandatory?

A)JAVA_HOME                           B)TALEND_HOME

C)TIS_HOME                                 D)JRE_HOME

9. What is the use of a tReplicate component? Choose one best answer?

A)To duplicate the configuration of an existing component

B)To copy the input row to an output row without processing it

C)To duplicate a sub job

D)To send duplicates of an output row to multiple target components

10. How do you see the configuration of an error message for a component in Talend studio?

A)Right-click the component and then click show problem

B)From the errors view

C)Place the mouse pointer over error symbol in the design workspace

D)From the problems view

11. How do you create a row between two components in Talend

A) Drag the target component to source component

B)Right-click the source component click Row followed by the row type and then click the target component

C)Drag the source component onto target components

D)Right-click the source component and then click the target component

12. How do you ensure that a subjob completes before a second subjob runs in Talend?

A)Using RunIf trigger

B)Using the main connection

C)Using onComponentOk or OnComponentError trigger

D)Using onSubJobOk or onSubJobError trigger

13. Which of the following the components will be used to load JSON file to MySQL database in Talend?

A)tMySQLInput

B)tFileInputJSON

C)tMySQLOutput

D)tMap

14. How do you run a job in Talend Studio?

A)Click the Run button in the Run view

B)Click the Run button in the Job view

C)Click the Run button in the File Menu

D)Click the Start button in the Run view



15. What is the best practice for arranging components on the design workspace in Talend studio?

A)Bottom to Top

B)Right to Left

C)Top to Bottom

D)Matching the flow of data

16. From which tab in component view would you specify the component label in Talend

A)View

B)Advanced settings

C)Basic settings

D)Documentation

17. How to place your component in a job in Talend Studio?

A) Click it on Edit Menu

B) Click it in the Repository and then click in the design workspace

C) Click it from Repository to the design workspace

D)Click it in the Palette and then click in the design workspace


Talend Questions for Certification

Sample Questions for Talend Certification




1. Which of the Following transformations/operations are possible for using tMap?

A) Lookup                                                           B)Join

C) Sorting                                                            D) Filtering

2. What is Job in Talend?

A) visual set of components graphically connected using different connections
B) visual set of metadata graphically connected using different components

C) collection of components and metadata
D)a & c

3. Which of the following component is used to generate sample data
A) tFixedFlowInput                                                              B)tGenerateDate

C)tRowGenerator                                                                D) tSampleData

4.Which Layout exported from a component in Talend
A)Excel format                          B)Text file

C)XML file                                       D)CSV file

5.Which of the following is a correct way to parse String column to Date

A)TalendDate.parseDate(“MM/dd/yyyy”, row2.date)
B) Date.parseDate(“MM/dd/yyyy”, row2.date)
C) TalendDate.getDate(“MM/dd/yyyy”, row2.date)
D)TalendDate.formatDate(“MM/dd/yyyy”, row2.date)

6. Which of the Following components are used to store log and statistical information about your job
A)tStatsCatcher
B)tLogCatcher
C)tFlowMeterCatcher
D)none of the above

7.In order to filter all files with a name having string “AMZ_AMZ001” using the tFileList component in Talend



A) Directory property should be set to “AMZ_AMZ001”
B)Set FileMask property to “AMZ_AMZ001”
C) Set FileMask property to “*AMZ_AMZ001*”
D)Set FileMask property to “*AMZ_AMZ001”

8. In which user interface element do you find Business Models, Job designs & Metadata?

A)The Job view                                                              B) The Repository

C)The design workspace                                          D)The Palette

9. What is indicated by an asterisk next to the job name in the design workspace

A)That this is an active job                              B)That the job contains an error

C)That the job contains unsaved changes  D)That the job is currently running

10. When you first start Talend Open Studio what are the advantages of creating a Talend account? Choose all that apply

A)You can visit MyTalend.com
B)You are required to create an account
C)You can post questions/answers to Talend forum
D)You can download components from Talend Exchange

11.From which View in Talend Open Studio would you clear the statistics from the design workspace? Choose one Answer
A)The component view
B)The context view
C)The problems view
D)The run view
E)The job view