Two sources - the New data of smaller volume and the Oracle 10g database( 10 million records).
The Oracle source contains a column to be used as the break key column for the selection of candidates.
Scenario 1: The Candidate Select is not used, matches are found in the New data source.
Scenario 2: The Candidate Select is used, matches are not found in the New data source.
Are there any parameters we should be checking?