Capgemini interview question

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