CODEWITHSUNDEEP
oracle11gmergeoracle-warehouse-builder
Nɪsʜᴀɴᴛʜ ॐ
Nɪsʜᴀɴᴛʜ ॐ

Reputation: 2914

Match-Merge operation for Record Linkage in Oracle Warehouse Builder

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.

Upvotes: 5

Views: 259

Answers (1)

Philippe
Philippe

Reputation: 1823

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

Upvotes: 1

Related Questions