Talend Interview Questions

What Talend stands for?

Talend stands for Talend Open Studio.

What types of joins are supported by the tMap component?

Inner, outer, unique, first, and all joins.

What do you mean by Talend?

Talend open studio is the open source data integration product produced by Talend and it is designed to convert, combine and update data in various areas across a business.

When was Talend open studio launched?

Talend launched in October 2006.

Talend is written in which language?

It is written in Java language.

Tell the latest version of Talend open studio?

The latest version is 5.6.0

Differentiate between ETL and ELT?

ETL stands for Extract, Transform and Load which is a process that involves gaining data from exterior source, converting it to get fit into operational requirement, then load it into the end target database.
ELT stands for Extract, Load and Transform which is the process in which data is get, then loaded into the staging table in the database and then data is converted according to the need.Read this incisive blog to clearly understand the process of ETL now.

What is the significance of tLoqateAddressRow component in Talend?

It is a component for mailing correct address belongs to the respective customer data to make sure a single customer view and good delivery for their respective customer mailing.

Could we change the background color of the job designer ?

Yes, we can change the background color of job designer.

How we can change the background color of job designer?

We can change the background of job designer by clicking on the preferences of the window menus, after the talend, appearance,designer then click on color menu.

Can we define a variable which can be accessed by many jobs?

Yes, we can declare a static variable in the rountine and add the setter method for the respective variable in the routine. Then this variable can be accessed from various jobs.

Can we save our personal settings in the DQ Portal?

No, we can not save our personal setting in the DQ Portal.

Can we change the generated code directly?

No, this is not possible we cannot generate code directly for Talend.

Which method we should use to include our own Java code in a Job?

We can use tJava, tJavaFlex component, tJavaRow, etc to include our own Java code in a Job.

Can we use Binary Transfer mode in SFTP ?

No, in SFTP we cannot use the binary transfer mode because SFTP is not like the FTP. Hence, we cannot apply the concept like ‘current mode directory’ and ‘transfer mode’.

For sorting data which component we generally use?

We can use tExternalSortRow and tSortRow.synthesizing sorted input.

In talend what is the fixed pattern of date?

By default the date pattern is dd-MM-yyyy.

What do you mean by component?

Component is simply a functional piece which is used for a single operation. It is a bundle of file kept within a folder named followed by component name.

Differentiate between ‘insert or update’ and ‘update or insert’ ?

Insert or update means first we insert a record, but if a record is matching with the primary key then the record is updated.
Update or insert means first we update the record with same primary and if the record doesn’t exists then we insert the record.

Differentiate between Repository and Built-In ?

In Built-In we can manually edit the data as data is kept locally in the job whereas in repository all the data is stored there only. We can extract only Read-only-information into the job from repository.