Talend Interview Questions

This is collection which I collected from across net for list of question you can get on Talend

1.     Difference between tMap and tJoin component in Talend .

2.    Difference between tAggregaterow and tAggregatesortedrow.

3.    Difference between tJava,tJavarow,tJavaflex.

4.    How to improve the performance of Talend job having complex design?

5.    Difference between built in schema and Repository.

6.    What is the declaration of method which we define in system routine?

7.    What is XMS and XMX parameter in Talend?

8.    How to resolve heap space issue in Talend ?

9.    How to do the exception handling in Talend?

10.  What is Default join for tMap.

11.  What are the different lookup patterns available with Talend?

12.  What is the basic requirement while updating the perticular table?

13.  How to generate surrogate key by using Talend?

14.  What is the use of Expression editor in Talend?

15.  How to debug a particular Talend job.

16.  What is context variable and context group?

17.  How to pass the variables from parent job to child job and from child job to Parent?

18.  How to forcefully exit the job.

19.  Explain the use of tContextload.

20.  How to execute multiple queries by using Talend?

21.  How to do the multithreading while executing the Job?

22.  What is hashmap in Talend and how to use it?

23.  How to do the full join in Talend.Explain the steps.

24.  How to do the right outer join in Talend? Explain the steps?

25.  How the ELT database components are differ from ETL database Components.

26.  How to use the external libraries in Talend?

27.  How to pass data from parent job to child jobs through tRunjob component ?

28.  How to load context variables dynamically?

29.  How to Share DB Connection in Talend?

30.  Skip Header rows and footer rows before load.

31.  What is Incremental Load? Describe using Talend.

32.  How can you pass a value form parent job to child job in Talend.

33.  How to call stored procedure and function in Talend Job

34.   What is Talend ?

35.   What is difference between ETL and ELT components of Talend ?

36.   How to deploy talend projects ?

37.   What are types of available version of Talend ?

38.   How to implement versioning for talend jobs ?

39.   What is tMap component ?

40.   What is difference between tMap and tJoin compoents ?

41.   Which component is used to sort that data ?

42.   How to perform aggregate operations/functions on data in talend ?

43.   What types of joins are supported by tMap component ?

44.   How to schedule a talend job ?

45.   How to runs talend job as web service ? 

46.   How to Integrate SVN with Talend ? 

47.   How to run talend jobs on Remote server ? 

48.   How to pass data from parent job to child jobs through trunjob component ?

49.   How to load context variables dynamically from file/database ?

50.   How to run talend jobs in Parallel ?

51.   What is Context variables ? 

52.   How to export a talend job ?

53.   Difference between TOS & TIS & ESB

54.    Difference between tJava, tjavarow & tJavaFlex

55.   How you perform Exception Handling without using component like tjava,tjavarow?

56.   How you design SCD component

57.   Transfer of context from main job to child job