Tata Consultancy Services interview question

They asked about your ETL tool, SQL, Linux. 1. What is target load order? 2. Write the difference between connected lookup and unconnected lookup. 3. How you identify duplicates and how to find latest duplicate