Talend Interview Preparation

When will you use Jdbc components and when will you use predefined database components?

Suppose i have 80% of data in dimension table in this scenario which schema will you prefer?

I have JVM parameters at job level, project level and tac level which one you chose first level to execute the job?

If source data is flatfile(simple notepad file) which component is used to load it?

What is the importance of parallel execution in talend and how we can achieve that?

What are the different lookups available in Talend (Tmap), Diff between All match and first match

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

I will get the new file every day into S3 folder. How to download all files from S3 folder using Talend ?

I want only date in output file without time stamp how would you do it like will you do any talend function

What are the differences from lower versions to higher Versions when compared to talend Components.

Reason for why we don’t get exit code as 1 even though the select query is wrong in talend

How to pass parameters from Child to parent & parent to child and how we pass dynamically.

In toracleinput in the only one query i'm using select* form tablename when i run a job it gives me error failed to recover internal representation, how will you resolve this error?

On what basis your validating the files in Talend and Which components you are using in talend to validate files ?

How do you identify if it is new record or existing records while implementing scd?

Have you worked on API's using talend and How can we extract data from API's using talend?

in talend how do you know that ,how many records are updated , how many records are inserted , and how many records are rejected  ?

If the Job is running for few minutes and it keep on increasing ,What would be the reason?

I have existing job, in this job i have one main and two lookup connections in tmap, i requested you to create third lookup what will be the process?you have to enhance the talend job and introduce the third lookup?

Every day the job running at 6am, client is going to send files at 7 am. How to load files after triggering?

Have you return any salesforce object query. What is record type object in Salesforce.

In Talend what are the critical issue you have faced while loading salesforce data.

Consider we having two components in a particular talend job one component should run on daily based and other component should run on after the 10th date on every month

Consider a scenario, we having set of files with in a path we need to read the file and insert into one table, suppose the insertion process is failed we need to move that file to failure folder , if the file is success we need to move that file to success folder

While extracting data from S3 and loading into snowfalke what are all the components used in talend

what are the differntiate among load once ,reload at each row & reload at each row cache?

We have 1 crore records in input , output should contains 10 files . Each file have 10 lakh

Suppose i want fetch 11 to 15th row and 20th row from a table how would you do in talend?

I have 5 sub jobs, I want to run first 3 sub jobs parallel and other 2 sub jobs parallel how would you do it?

I have table with date format as dd-mm-yyyy in target table we need to get the date format as yyyy-mm-dd

How we get first 100 records from a CSV file, last 100 records from a CSV file and how we get if we have actual header

Take a scenario i have a folder i will get files daily suppose its a sales file with file nomenclature like this sales_06022024.csv and yesterday file is sales_05022024

and based on files coming to the folder i want your approach all the incremental loads we need to load, based on the path we need to specify we need to take the latest file and load it to SQL server?

I have a file which consists of 10000 records i want to process for each iteration 2500 records

I want to compare multiple files from different directories in a drive how would you do it in talend?

There are files in directory and we need to process them in the work day only(i.e., from Monday to Friday) and we need to process +4 days and -4 days from the current day. how do you achieve it by using talend?