Talend Interview Preparation

Course Curriculum

Chapter 1: Introduction to our Talend Course

Lecture 1: Introduction to Talend Interview Questions Course

Chapter 2: Basic Questions

Lecture 1: What is Talend?

Lecture 2: Which Programming Language supports Talend?

Lecture 3: What are Context Variables?

Lecture 4: What are the different ways to use Context Variables?

Lecture 5: What are Global variables?

Lecture 6: How to change the background color of the job designer in the Talend?

Lecture 7: How you migrated the code from one environment to another environment?

Lecture 8: How to resume job execution from same location if job get failed in Talend?

Lecture 9: How to execute multiple SQL statements with one component in Talend?

Lecture 10: What is Batch Process?

Lecture 11: When ever reject row disable what is the process?

Lecture 12: How to get the files from S3 bucket to the Talend server?

Lecture 13: How to schedule a job in TAC to run on every month of Friday?

Lecture 14: Types of connections in Talend

Lecture 15: Components_List

Lecture 16: Data ware house data is loaded first into which table fact or dimension and why

Lecture 17: Can you tell me what is the importance of data mart why do we require it ?

Lecture 18: As we have the primary key what is the necessity of surrogate key in DWH?

Lecture 19: Can you tell me what is the significance of surrogate key in data warehousing ?

Lecture 20: Explain about TMC execution plan.

Lecture 21: How you achieve data cleansing on large data sets?

Lecture 22: How to load the database table into local server?

Lecture 23: Using dynamic schema how can you find out what type of datatype and each colum

Lecture 24: How to change file format using Talend?

Lecture 25: What are optimise ways to handle Heap space memory issue?

Lecture 26: What is MDM(Master data management)?

Lecture 27: How you run the job irrespective of the job status?

Lecture 28: How you run talend job outside talend?

Lecture 29: How you load XML data into multiple targets?

Lecture 30: How to perform aggerate operations/functions on data in Talend?

Lecture 31: Is there any other component to load data other than tDBInput component?

Lecture 32: Merge multiple files into single file with sorting operation?

Lecture 33: In how many levels we can change JVM parameters?

Lecture 34: ROWNUM analytical function in Talend?

Lecture 35: When will you use Jdbc components and when will you use predefined database comp

Lecture 36: How can I execute multiple commands at one time with a tsystem component?

Lecture 37: Why do we use Denormalized data in Dataware house?

Lecture 38: Is it possible to create a version in talend?

Lecture 39: How to extract data from json file without using tjson extractor

Lecture 40: What is ASCII and Binary connection in FTP connection?

Lecture 41: How to load lookup parallelly in tMap ?

Lecture 42: What are the challenge you have faced while read the XML file and that error?

Lecture 43: How do you remove the files from internal stage after loading the data?

Lecture 44: Have you consumed Json and XML files earlier?

Lecture 45: Suppose i have 80% of data in dimension table in this scenario which schema will

Lecture 46: What is the significance of tSchemaComplianceCheck and what is the use of it?

Lecture 47: Can I use tjava as tjavarow?

Lecture 48: I want to load 100 tables from oracle to cloud how would you do it?

Lecture 49: How did you handled error optimize mechanism in your project?

Lecture 50: I have JVM parameters at job level, project level and tac level which one you ch

Lecture 51: How would you perform incremental load in your project?

Lecture 52: How to perform rate limiting in rest API?

Lecture 53: What is joblet ? What is the use of joblets

Lecture 54: What is outline view in Talend ? What is the use outline view?

Lecture 55: If source data is flatfile(simple notepad file) which component is used to load

Lecture 56: What is the use of tBufferInput and tBufferOutput

Lecture 57: What is the importance of parallel execution in talend and how we can achieve th

Lecture 58: What is the use of API component and how we can call API component in talend

Lecture 59: What are the different lookups available in Talend (Tmap), Diff between All matc

Lecture 60: How we run a job in Talend server which is developed in Talend studio

Lecture 61: What is the command to load data into existing HIVE table, how many ways are the

Lecture 62: Which component we use to get data from HIVE ?

Lecture 63: What are the configurations we will use in talend to make a API call

Lecture 64: What are the test cases in talend studio?

Lecture 65: What are the optimization techniques in talend

Lecture 66: Explain about error log mechanism in talend

Lecture 67: What are the steps you are following while creating jobs start to end in talend?

Lecture 68: How do we perform data validation and data cleaning using Talend?

Lecture 69: I will get the new file every day into S3 folder. How to download all files ….

Lecture 70: How could you pass nested loops in xml threads?

Lecture 71: What are the Different ways to connect SOAP API?

Lecture 72: What are the parameters we need to connect tHDFS component ?

Lecture 73: Which component is better to use tMap or tJoin when job a support two components

Lecture 74: How we load context from a parameter file

Lecture 75: In which scenario we use post method in Talend

Lecture 76: I want only date in output file without time stamp how would you do it like ….

Lecture 77: In Talend how to perform insert and update operation to any of the databases

Lecture 78: What is pagination

Lecture 79: How do you maintain branching’s in that it is in environment level

Lecture 80: What are the operations branching of git how do you checkout

Lecture 81: What is emit functionality in Talend ?

Lecture 82: What is thmap in Talend

Lecture 83: Who takes care of pull and merging in git

Lecture 84: In staging why do we go for truncate and load why cant we use incremental data

Lecture 85: What is the performance of ETL and timing?

Lecture 86: Have you implemented any subscriptions like email subscriptions?

Lecture 87: How to deploy the Code from talend to TMC.

Lecture 88: What are the differences from lower versions to higher Versions when compared to

Lecture 89: What is Dynamic schema in Talend?

Lecture 90: Reason for why we don’t get exit code as 1 even though the select query is wrong

Lecture 91: How to pass parameters from Child to parent & parent to child and how we pass ..

Lecture 92: How to delete data from HIVE table

Lecture 93: How will you check date format in tSchemaComplianceCheck

Lecture 94: In toracleinput in the only one query i'm using select* form tablename when i ..

Lecture 95: What is the functionality of tMap.

Lecture 96: Can we use tBuffer multiple times in job? Why?