- Posts: 371
- Thank you received: 3
Deduplicator - how?
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.
10 years 1 month ago #7907
by admin
Mike
ETL Architect
Replied by admin on topic Deduplicator - how?
I belive you shoul sort the data first
Eg
Reader-> some transformation->sorter->deduplicator->transformation->Writer
Mike
Eg
Reader-> some transformation->sorter->deduplicator->transformation->Writer
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
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:
At the bottom:
Note:
There is no need to sort data before deduplication
Please Log in or Create an account to join the conversation.