Dynamic Comparison (or joins)

cjj — Wed, 17 Aug 2016 12:27:14 GMT

Hi all,

I'm confusing myself thinking of the possibilities for this, and will be the first to admit I'm by no means a Guru with Talend. I'm currently on v6.2 of TOS for Data Integration.

Scenario
I'd like to be able to compare table A with table B. This will mainly be a matching/non-matching field output, which is simple enough with a tMap and rejected joins etc.
Where it gets trickier - is it possible, with a Context load and some Java components etc., to define two tables of choice, say "Users A" and "Users B", then have a job dynamically look at the matching columns for each, then compare the contents of the matching columns?
Essentially, the schema/fields are considered "unknown", and the TOS job would require the ability to determine the table schema, then automatically join the identical column names.

Is this possible, or am I on a fools errand here?

(I have attached an incredibly crude picture to demonstrate, or attempt to demonstrate, what I'm trying to do)

Many thanks for reading

Re: Dynamic Comparison (or joins)

gorotman — Wed, 17 Aug 2016 14:37:07 GMT

Hi,
not simple to do....take a look to this: A Talend Open Studio Walkthrough: Dynamic Schemas
Your attachment is missed?! :-)
bye

Re: Dynamic Comparison (or joins)

TRF — Wed, 17 Aug 2016 14:40:15 GMT

Hi,
Suggest you to read about dynamic schema at http://bekwam.blogspot.fr/2011/06/dynamic-schemas-in-talend-open-studio.html?m=1

Regards,
TRF

topic Re: Dynamic Comparison (or joins) in Talend Studio

Dynamic Comparison (or joins)

Re: Dynamic Comparison (or joins)

Re: Dynamic Comparison (or joins)