Hexaware Technologies interview question

Aggregate functions, SCD 2, Star Schema,Joins, Informatica power center