Wednesday 21 August 2013

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 ?