You can remove duplicates by using either select Distinct or Order by clause at the end of the SQL over ride in source qualifier