Deduplicator - how?

More
10 years 1 month ago #7903 by ckelsoe
Deduplicator - how? was created by ckelsoe
I need to deduplicate the resulting transformation just before it goes to the writer. I added it in between and set the one field that I needed to use to deduplicate the data. I am getting a large number of errors now. What is the best working way to deduplicate the results of the transformation prior to it getting written?

Please Log in or Create an account to join the conversation.

More
10 years 1 month ago #7907 by admin
Replied by admin on topic Deduplicator - how?
I belive you shoul sort the data first

Eg

Reader-> some transformation->sorter->deduplicator->transformation->Writer

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
10 years 1 month ago #7911 by ckelsoe
Replied by ckelsoe on topic Deduplicator - how?
Guess that is what I get for reading instructions: www.etl-tools.com/processing-data/data-deduplication.html

At the bottom:

Note:
There is no need to sort data before deduplication

Please Log in or Create an account to join the conversation.

More
10 years 1 month ago #7912 by admin
Replied by admin on topic Deduplicator - how?
So is it working now or not?

M

Mike
ETL Architect

Please Log in or Create an account to join the conversation.