Talend Interview Questions

Talend Interview Questions

  • What’s Talend Open Studio?

Talend Open Studio for statistics Integration is an open source facts integration product developed via Talend and designed to mix, convert and replace information in numerous places across a business.


Talend Interview Questions

  • While was Talend Open Studio come into lifestyles/launched?

Released in October 2006


  • Talend Open Studio is written in which computer language?



  • What’s the maximum present-day model of Talend Open Studio?

Talend Open Studio 5.6.0


Talend Interview Questions

  • What’s the distinction between the ETL and ELT?

ETL: Extract, transform, and cargo (ETL) is a system that entails extracting facts from outside assets, remodeling it to fit operational wishes (now and again using staging tables), then loading it into the cease target database or statistics warehouse. This method is reasonable as long as many unique databases are worried to your facts warehouse landscape. On this situation, you need to delivery statistics from one region to any other besides, so it’s a legitimate manner to do the transformation paintings in a separate specialized engine.

ELT: Extract, Load, remodel (ELT) is a technique in which facts are extracted, then loaded right into a staging table in the database, remodeling it where it sits inside the database and then loading it into the target database or information warehouse.


  • What’s the use of tLoqateAddressRow component in Talend?

This thing is used for correct mailing addresses associated with client information to make sure an unmarried client view and better transport for his or her patron mailings.


Talend Interview Questions

  • Can you outline a schema at run time?

No, schemas have to be defined at some point of layout, now not run time.


  • Are you able to outline a variable that is available from a couple of Jobs?

Yes, you could declare a static variable in a habitual, and add the setter/getter techniques for this variable inside the habitual. The variable is then reachable from one of a kind Jobs.


Talend Interview Questions

  • Are you able to save my non-public settings inside the DQ Portal?

No, you couldn’t.


  • Are you able to edit generated code immediately?

a.This is no viable; you can’t immediately edit the code generated for a Talend task.
In case you need to consist of your own Java code in a task, use such a strategies:
Use a tJava, tJavaRow, or tJavaFlex aspect.
Create an ordinary via proper -clicking routines under Code within the
Repository after which clicking Create routine

  • Why is Talend called a Code Generator?

Talend provides a user-friendly GUI where you can simply drag and drop the components to design a Job. When the Job is executed, Talend Studio automatically translates it into a Java class at the backend. Each component present in a Job is divided into three parts of Java code (begin, main and end). This is why Talend studio is called a code generator.

  • Explain Routines.

Routines are the reusable pieces of Java code. Using routines you can write custom code in Java in order to optimize data processing, improve Job capacity, and extend Talend Studio features.
Talend supports two types of routines:
System routines: These are the read-only codes which you can call directly in any Job.
User routines: These are the routines which can be custom created by the users by either creating new ones or adapting the existing ones.
  Talend Interview Questions

  • What are the various types of schemas supported by Talend?

Some of the major types of schemas supported by Talend are:
Repository Schema: This schema can be reused across multiple jobs and any changes done will be automatically reflected to all the Jobs using it.
Generic Schema: This schema is not tied to any particular source & is used as a shared resource across multiple types of data sources.
Fixed Schema: These are the read-only schemas which will come predefined with some of the components.

  • can you define a variable which can be accessed from multiple Jobs?

Yes, you can do that by declaring a static variable within a routine. Then you need to add the setter/getter methods for this variable in the routine itself. Once done, this variable will be accessible from multiple Jobs.

  • What is a Subjob and how can you pass data from parent Job to child Job?

A Subjob can be defined as a single component or a number of components which are joined by data-flow. A Job can have at least one Subjob. To pass a value from the parent Job to child Job you need to make use of context variables.

  • Define the use of ‘Outline View’ in TOS.

Outline View in Talend Open Studio is used to keep the track of return values available in a component. This will also include the user-defined values configured in a tSetGlobal component.

  • What is a scheduler?

A scheduler is a software which selects processes from the queue and loads them into memory for execution. Talend does not provide a built-in scheduler.


This information box about the author only appears if the author has biographical information. Otherwise there is not author box shown. Follow YOOtheme on Twitter or read the blog.
+91 9952948899 info@kyrosacademy.com