topic Change db columns name and tMap schemas in Talend Studio

Change db columns name and tMap schemas

Rosanero4Ever — Tue, 30 Oct 2018 14:45:16 GMT

Hi all,

I developed some jobs which insert data into some database tables using excel files as data inputs

Now, I have to change the destination columns name of some destination tables.

So, I need to change each job in order to fit the new destination table metadata

In your opinion, what's the fastest way to perfom this?

Shall I edit manually each tMap in each job? I don't hope in this solution....

Many thanks in advance for your advices.

fdenis — Tue, 30 Oct 2018 15:48:50 GMT

did you retrieve and store schemas of tables into metadata.
it's the best way.
if you update schema propagation may help you.

Rosanero4Ever — Tue, 30 Oct 2018 15:55:29 GMT

Hi,

your solution is good if schemas are related to repository metadata.

Unlucky, my schema are integrated in the job and so schema propagation doesn't occurs in this scenario.

Have you any other advice, please?

fdenis — Tue, 30 Oct 2018 16:05:36 GMT

retrieve schema from db
update jobs to link to metadata.
then update metadata