Match-Merge operation for Record Linkage in Oracle Warehouse Builder

Question

I am new to OWB and performing Match-Merge operation.

Input data
Source(Database) : 22,33,000 records
Target : 1000 records

Actual Output
20,00,000 records

Expected Output
Match-Merge Table: <= 1000 records

I am unable to figure out why i am getting such a huge number in Output of Match-Merge Table which was unexpected.

Please help me by guiding what are all the steps to be followed to reduce the Actual Output to approx. 1000 records.

Answer 1

This is a good starting point for what you are asking for

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/owb/10gr2_owb_extend/matchmerge/matchmerge.htm