Capgemini Interview Question

Dimension table Fact table Full load n incremental load Query to find duplicates