Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Update all table in one transformation job

Is it possible to perform table update transformation job on all tables from on schema to another.

1 Community Answers

Matillion Agent  

Laura Malins —

Hi Akshay

Apologies but I’m not exactly clear on what you’re asking. Are you asking if it’s possible to update many or all tables that exist in one schema with information from tables in another schema?

This is possible in Matillion. In the Table Input component you can choose which schema to pull your table from and this can feed into a Table Update component in a different schema. There’s no way in the job to automatically have that apply to every table in the schema. You could have one Table Input component with a corresponding Table Update component per table. But I would look at using a job with variables for the table name and connecting that to an iterator.

I hope that helps.

Thanks
Laura

Post Your Community Answer

To add an answer please login