Remove Duplicate Error

aschand · Post by **aschand** » Thu Jan 24, 2008 6:34 pm

RemoveDupBUOMErrs: Key field "SOURCE_SYSTEM_CODE" was not found in the view-adapted input schema
Key field "SOURCE_COMPANY_CODE" was not found in the view-adapted input schema
Key field "FROM_CODE_VALUE" was not found in the view-adapted input schema
Key field "ERROR_MSG" was not found in the view-adapted input schema

please help how do i solve it... and what does it mean

thanks
aschand

keshav0307 · Post by **keshav0307** » Thu Jan 24, 2008 6:43 pm

what is your source, is it a database table, file or dataset.
can you darw the flow.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 24, 2008 7:55 pm

What columns are on the input link of the RemDups stage, and which of these are marked as keys for the purpose of removing duplicates?

What columns are on the output link, and how are these mapped from the input link (look on the Mapping tab of the output link)?

Are the data partitioned and sorted on the remove duplicate keys?