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
