We have to create several job doing exactly the same thing, but with differents input/output table.
The job will run as follow:
We need to create 5 or 6 times this job, with a different input and output table. To me, the best practice would be to create a "generic job", passing input and output table as parameters to the job.
The problem is these input/output table don't have the same data structure.
Does anybody have an idea on how to dynamically specify the table structures?
Thanks in advance for your help,
Talend version: Talend Data Integration v6.3.1
Database type: Postgresql (> v10)
Talend Dynamic schema feature will allow you to design schema with an unknown column structure (unknown name and number of columns).
Could you please let us know if this article helps?
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.