Infosys Certified Pentaho Data Integration Developer
Practice with real exam-pattern questions for Infosys Certified Pentaho Data Integration Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Pentaho Data Integration Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Pentaho Data Integration Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
You have been given a task to extract data from a text file and load it into a database table. The data in text file is arranged using fixed width delimiter. Which step will you use to extract data from the text file? (Select all possible options)
- ✓Text File InputCorrect
- BFlat File Input
- CFixed File Input
- DFile Input
- Question 2
You have sales order data in SaleOrders.xls and product details in Product.xls. Which join type will you use to return rows from the second source, with empty values for non-matching keys in the first data stream?
- ✓LEFT OUTERCorrect
- BRIGHT OUTER
- CFULL OUTER
- DINNER
- Question 3
You are creating a transformation to split employee’s data Gender wise. The employee details are stored in Employee Table. The male employee’s data should be stored in Male_Emp.xls and female employee’s data should be stored in Female_Emp.xls files. Which step you can use?
- ✓Switch CaseCorrect
- BRouter
- CFilter Rows
- DConditional Split
- Question 4
You are configuring a step to generate sequence. The property values are given as below. Start at = -1 Increment by -1 Maximum value -2 Identify correct result.
- ✓-1, -2, -1, -2…Correct
- B-1, -2, 0, -1, -2…
- C-1, -2, 0, 1, 2…
- D-1, 0, -2, -1, 0, -2…
- Question 5
If you have to combine data from Sales1.txt and Sales2.csv into SalesData.xls, but want to assure that data from Sales1.txt must be loaded first. Which property in Append Stream step will you set?
- ✓Head hopCorrect
- BFirst hop
- CTop hop
- DPrimary hop
- Question 6
Identify the correct steps to create a connection with the Microsoft SQL server database in Table Input step. 1>Under settings set all required properties like hostname, port etc. 2>Under general tab specify connection name 3>Select access mode [Native(JDBC), ODBC, OCI, JNDI] 4>Against connection property click on New button 5>Select connection type as MS SQL Server
- ✓1,2,3,4,5Correct
- B4,2,5,3,1
- C2,4,5,1,3
- D4,2,5,1,3
- Question 7
Select perfect example of data transformation
- ✓Filtering employee data based on their genderCorrect
- BSorting Employees data based on their employee id in ascending order
- CCalculating Total salary for each employee based on given salary and bonus
- DAll of the above options
- Question 8
You are reading data from a text file using the Text File Input step. You do not want to send empty rows to the next step, if exists any. Which one of the following actions will you perform?
- ✓Under Content tab check ‘No empty rows’ propertyCorrect
- BUnder Content tab uncheck ‘Empty rows’ property
- CUnder Content tab uncheck ‘NULL rows’ property
- DUnder Fields tab uncheck ‘NULL rows’ property
- Question 9
Identify the default delimiter for Fixed File Input step.
- ✓SemicolonCorrect
- BSpace
- CTab
- DNone of the above options
- Question 10
You have been given a task to extract data from a text file and load it into a database table. The data in text file is arranged using fixed width delimiter. Which step will retrieve data faster from text file?
- ✓Text File InputCorrect
- BFlat File Input
- CFixed File Input
- DCSV File Input
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.