Talend Interview Questions

Dear Developers,

After receiving several requests we have finally decided to start writing interview questions that are generally asked in any of the Talend data integration Interview.

First we have to think about what,where,when ???

What is TDI?

What are the versions available?

What is the difference between TDI and TDQ?

What are the difference between open source and licensed tools?

Talend - Merge multiple files into single file with sorting operation.

Loading Fact Table Using Talend

ROWNUM Analytical Function in Talend

SCD-2 Implementations in Talend

Deployment strategies in Talend

Custom Header Footer in Talend

Data Masking Using Talend

How to use Shared DB Connection in Talend

Load all rows from source to target except last 5

Late Arriving Dimension Using Talend

Date Dimension Using Talend

Dynamic Column Ordering Of Source File Using Talend

what is difference between ETL and ELT components of Talend ?

how to deploy talend projects ?

what are types of available version of Talend ?

how to implement versioning for talend jobs ?

what is tMap component ?

what is difference between tMap and tJoin compoents ?

which component is used to sort that data ?

how to perform aggregate operations/functions on data in talend ?

what types of joins are supported by tMap component ?

Big Data EveryWhere!

•Lots of data is being collected and warehoused

–Web data, e-commerce

–purchases at department/

grocery stores

–Bank/Credit Card 

transactions

–Social Network

DWBI Training Info

DWBI SOLUTIONS has experience in teaching a wide variety of technologies ranging from databases to business intelligence. DWBI SOLUTIONS has some of the best instructors in the industry for Data warehousing & Business Intelligence Training.

Classes can be customized or created to meet your needs. We can provide classroom-style instruction at our own facilities or on-site at your location. We can also provide individual hands-on remote mentoring using teleconferencing. We generally use the latest released version of the software for our classes. Instructor-led courses from DWBI SOLUTIONS may be taught at your location, and can be presented to as many as 5 students per class. To find out more, including scheduling and pricing, call us at +91 9561868844 or write to prasad7350@gmail.com.

We offer Scenario-based business intelligence training with hands on experience for different courses for the following technologies:

Business Intelligence & Information Delivery Technologies

· Cognos

· OBIEE

· SSRS

· 1 Key Agile

Relational Database Management Systems

· Oracle

· SQL Server

· mySql

· MS Access

Extract, Transform & Load (ETL) Technologies

· Pentaho

· Informatica

· Oracle Data Integrator

· SSIS

· DataStage