When Salesforce objects are used as a source, by default the archived and deleted records in the salesforce object are omitted from search query. To include the archived and deleted records in search query enable the Include archived and deleted rows in the Source option available under Query Options of a source transformation.