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

1st Round was telephonic--> Asked basic about router ,lookup and joiner transformation,Lookup Caches,Difference between unconnected Lookup and connected Lookup. 2nd Round Virtual Technical Interview: How would get specific number record to target like 1st and 3rd. SCD Types Schema Change Handling Aggregation Working on performance tuning in Informatica Powercenter