topic Re: Checking differences between 2 tables in Talend Studio

Checking differences between 2 tables

JayQueue — Fri, 15 Nov 2024 22:59:32 GMT

Hello,

I'm comparing 2 tables for differences and my method is now:

ThashInput -> tMap <- - -> Lookup table and inner join on Field1. Catching rejects

OnSubjOk

Thashinput -> tMap

<- - -> Lookup table and inner join on Field2. Catching rejects

OnSubjOk

Thashinput -> tMap

<- - -> Lookup table and inner join on Field3. Catching rejects

...

(only 5 fields)

And I was wondering if there's a better/cleaner/re-usable way to do this? I looked on the Exchange but I couldn't find anything

Thanks!

Jonathan

Re: Checking differences between 2 tables

gjeremy1617088143 — Mon, 25 Apr 2022 07:22:55 GMT

Hi @Jonathan Quartier , i can suggest you to use tAddCRCrow on each table to make Unique ID for Each combinaison of fields and compare them in a lookup, if you have difference then ,look in more detail field by field.

Re: Checking differences between 2 tables

JayQueue — Mon, 25 Apr 2022 09:40:54 GMT

Thanks @guenneguez jeremy so not much different than I'm doing now.

It's a small dataset so I don't 9know if performance will increase with the tAddCRCrow but I'll keep that component in mind 🙂 Thanks for the tip!