Talend Scenario Based Questions

The Blog focuses on all Related interview questions required at Scenario level with Solution description.

Find the 2nd highest salary from empolyee table

Solution: https://www.youtube.com/watch?v=OKSvVi7kA4M

Talend job design:

Subscribe to: Posts (Atom)

Search This Blog

Followers

tJoblet vs tRunjob
tnormalize vs denormalize
TMC vs TAC
tJava vs tJavaRow vs tJavaFlex
tfixedflowinput vs trowgenerator
what are context variables and how do you load them ?
How can we run any job from studio to remote server?
When will you use Jdbc connection components and when will you use pre defined database components?
How to mask the domain name of a website from website column from table?
Types of connections inTalend
Components_List
Find count of columns in a file using Talend?
Find the 2nd highest salary from empolyee table
tContextLoad vs tContextDump
How to schedule a job in TAC to run on every month of Friday
How to run subjobs according to the input file we get from FTP server
How to replace null values with pervious values in a column?
Can we use tjava component as tjava row ?
Suppose I want to process all the files in a particular folder other than xml file .How would you do it ?
How to retrieve companies latest year revenue using Talend?
So , suppose I want to load lookup parallelly in tmap how will you do it ?
The data ware house data is loaded first into which table fact or dimension and why ?
Can you tell me what is the importance of data mart why do we require it ?
Can you differentiate between data warehouse and data lake which you will be using in the project.?
As we have the primary key what is the necessity of surrogate key in dataware house ?
Can you tell me what is the significance of surrogate key in data warehousing ?
Difference between FTP vs SFTP
What is nexus repository and artifact repository?
Explain about TMC execution plan.
How do you remove the files from internal stage after loading the data?
How you achieve data cleansing on large data sets?
How to load the table data into local server?
Using dynamic schema how can you find out the in what type of data set & each column using dynamic schema?
How to get unique values using Talend?
How many ways to load context variables?
Check whether id column in a file in serial or not using Talend.
Explain Talend Architecture?
What are optimise ways to handle Heap space memory issue?
How to change file format using Talend?
How you run talend job outside talend?
How you run the job irrespective of the job status?
What is MDM(Master data management)?
How to find the count of words in a sentence by using Talend?
How you handle Heap memory issue?
Is there any other component to load data other than tdb components?
How you call functions in Talend?
How you load XML data into multiple targets?
How to extract first middle and last name?
How to remove duplicates using Talend?
We have 1crore records in input ,output should contains 10 files . Each file should have 10lakhs records.
In how many levels we can change JVM parameters?
tbuffer vs thash
types of match modules in tmap
Open Studio talend vs Enterprise Version Talend
How to perform full outer join in Talend?
tFlowToIterate vs tIterateToFlow
Implicit context load vs Explicit context load
How to call routine in a job?
Context variable vs Global variable
Simple triggers vs Cron triggers
tDbinput vs tDbrow
TMC vs TAC
tnormalize vs denormalize
tJoblet vs tRunjob
what are context variables and how do you load them ?
tfixedflowinput vs trowgenerator
tJava vs tJavaRow vs tJavaFlex
tfixedflowinput vs trowgenerator
what are context variables and how do you load them ?
How can we run any job from studio to remote server?
When will you use Jdbc connection components and when will you use pre defined database components?
How to mask the domain name of a website from website column from table?
Consider we have two inputs main and lookup, how to capture first matching records into 1st output and remaining records into 2nd output ?
How to get the files from S3 bucket to the Talend server?
When ever reject row disable what is the process?
What is Batch Process?
How do you create fact table and dimension table in your project and explain it?
How to use a TAC job conductor?
How to perform aggerate operations/functions on data in Talend?
Custom header footer in Talend?
SCD-2 implementation in Talend?
How to pass data from the parent job to child jobs through trunjob component?
How to deploy the Talend projects/jobs?
Difference between the TOS for DATA Integration and TOS for BIG DATA?
How to send email notifications with job execution status?
Merge multiple files into single file with sorting operation?
How to load fact table using Talend?
ROWNUM analytical function in Talend?
How to use share DB connection in Talend?
What is tlogcatcher and tstatcatcher?
How to resume job execution from same location if job get failed in Talend?
How to iterate filenames and directories in Talend?
How to optimize Talend job to stop out-of-memory runtime error?
How to execute multiple SQL statements with one component in Talend?
How can I execute multiple commands at one time with a tsystem component?
taggregaterow vs taggregatesortedrow
Bulitin vs Repository
How you migrated the code from one environment to another environment?
Passing a value from a parent Job to a child Job
Passing a value from the child Job to the parent Job
Generic scheme vs repository schema
Tmap vs Tjoin
How to convert single column into multiple columns using talend?
Every day the job running at 6am, client is going to send files at 7 am. How to load files after triggering?
How to skip the particular record in talend
How to get the latest file from the directory ?
How to load all rows from source file to target table except last 5 rows?
How to implement Incremental load using Talend?
In delimited file we need to split the rows? How can we do it?
How to get Unique values using Talend?
How to run jobs parallely?
How to separate files based on country names?
How to load multiple files having same schema from a directory into one target table using single job
Load Multiple CSV files with different Structure
Why do we use use denormalized data in Dataware house?
What is pagination?
For example we have product sales across all the countries, i want to see the summery of the sales in a country how would you do it in Talend?
In Talend have you performed insert and update operation to any of the databases?
Have you worked on date formatting situations in any of the project?
I want only date in output file without time stamp how would you do it like will you do any talend function or do something else?
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?
What is emit functionality in talend?
Do you know about thashmap and have you used anywhere?
Do you know about thashmap and have you used anywhere?
What is thamp in talend?
what is the performance of ETL and timing?
we have three sources oracle,mysql,excel i want to integrate data from these three Sources in to my source database which is my target using talend.What all components, & what all considerations u will take into account in order to build the mapping?
Have you implemented any subscriptions like email subscriptions?
Reason for Why don't we get exit code as 0 even though the select query is wrong.
I have 3 jobs if job failed it should run from the point of failure.
onsubjobOk and oncomponentOk
what is Dynamic schema
what is composite key
What is log 4j in talend and in which component it is located?
How will you check date format in tSchemaComplianceCheck?
if we have 10 excel files which are in AWSs3 location how will you load the table in database oracle/postgres? IN this flow if the file is not correct how will you recect it?
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?
What is the functionality of tMap?
Can we use tBuffer multiple times in job? Why?
On what basis your validating the files in Talend and Which components you are using in talend to validate files ?
Where are you maintaining Staging Area?
How do you identify if it is new record or existing records while implementing scd?
What are the other components used in the talend while developing the job?
Why you develop joblets what is the use of it?
Have you worked on API's using talend and How can we extract data from API's using talend?
When you are working on development ,What are the major issues you are faced ?
What are the performing increasing techniques use in talend
What is the default join for tJoin component.
In how many ways we can create global variables
What is your experience on Data Quality and Data Profiling
If the Job is running for few minutes and it keep on increasing ,What would be the reason?
what are the difference among load once ,reload at each row & reload at each row cache?
while extracting data from S3 and loading into snowfalke what are all the components used in talend
There is a one flatfile in that we have multiple departments data so i want to load that data in multiple outputs like each dept table into separate output file so i want to develop in a dynamic way.suppose if we have 5 departments data today i need to generate 5 files tomorrow there are 10 departments i need to generate 10 files, how can we develop the job?
I have a file which consists of 10000 records i want to process for each iteration 2500 records
if we have 10 excel files which are in AWS S3 location how will you load the table in database oracle/postgres ? IN this flow if the file is not correct how will you reject it"
If job failed at 50th row when we run next time it should start from 51th row, what is your approach.
I want to compare multiple files from different directories in a drive how would you do it in talend?
What are Global variables?
How to change the background color of the job designer in the Talend?
How you run the job irrespective of the job status?
Is it possible to create a version in talend?
How to extract data from json file without using tjson extractor?
What is ASCII and Binary connection in FTP connection?
What are the challenge you have faced while read the XML file and that error?Have you consumed Json and XML files earlier?
Suppose i have 80% of data in dimension table in this scenario which schema will you prefer?
What is the significance of tSchemaComplianceCheck and what is the use of it?
I want to load 100 tables from oracle to cloud how would you do it?
How did you handled error optimize mechanism in your project?
I have JVM parameters at job level, project level and tac level which one you chose first level to execute the job?
How to perform rate limiting in rest API?
What is outline view in Talend ? What is the use outline view?
If source data is flatfile(simple notepad file) which component is used to load it?
What is the use of tBufferInput and tBufferOutput
What is the command to load data into existing HIVE table, how many ways are there?
I have 10 files present in source(local) path, I want to move all the files in to HDFS path, how to do that?
Which component we use to get data from HIVE ?
What are the configurations we will use in talend to make a API call?
What are the test cases in talend studio?
Explain about error log mechanism in talend.
What are the steps you are following while creating jobs start to end in talend?
How do we perform data validation and data cleaning using Talend?
I will get the new file every day into S3 folder. How to download all files from S3 folder using Talend ?
How could you pass nested loops in xml threads?
What are the Different ways to connect SOAP API?
What are the parameters we need to connect tHDFS component ?
Which component is better to use tMap or tJoin when job a support two components?
In which scenario we use post method in Talend?
How do you maintain branching? in that it is in environment level
What are the operations branching of git how do you checkout?
Who takes care of pull and merging in git?
The customer give some requirement where you have to implement thmap and you do not have any one in the team who knows thmap?
In staging why do we go for truncate and load why cant we use incremental data?
How to deploy the Code from talend to TMC?
What are the differences from lower versions to higher Versions when compared to talend Components?
How to delete data from HIVE table?
What is push integration ? What is pull integration?
How do you know that ,how many records are updated , how many records are inserted , and how many records are rejected?
How to load fact table using Talend?
Difference between Git versioning and Job versioning
Difference between joblet and child job
Difference between partition and bucketing.
Difference between tRest & tRestClient
Difference between reject and error reject
Find count of columns and Rows excluding Header in a file using talend?
Find count of rows in a file using talend?
How to convert relational data into Json data using Talend?
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 to do it using Talend?
In tMap how can we add custom columns in output.
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?
I want to send XML data to web API call, how we design Talend job.
How to get the first two max salary in each department using talend?
How to convert single column into multiple columns(multiple record) using Talend?
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?
Some times it is not possible to pass Json file. What is the Java code we need to write in Talend ?
Write condition in tMap expression builder(i.e.,if the branch is CSE then computer science, IT then Information Technology, Other than CSE or IT then it is Other ) . tomorrow let we go through once bro

Subscribe To

Posts

Posts

All Comments

All Comments

Simple theme. Powered by Blogger.