Change db columns name and tMap schemas

[Rosanero4Ever]

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]

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

[Rosanero4Ever]

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]

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