Skip to Content
Former Member
Nov 27, 2012 at 02:25 AM

How to change the schema name in a convenient way


Hi all,

Currently when I need to change the schema names for all tables in a job, I need to export to the .atl/.xml file, correct the schema name and re-import the file manually. Or I need to export to another repository and change the schema name meanwhile. (I mean schema name, not the owner name of the tables).

I think these methods are quite troublesome and unreasonable because I need to export/import the jobs.

Are there any convenient way to change the schema names of the tables? For instance using a parameter or variable like the other ETL tools do.