Target Table Schema

[sardarabdullahkhawar]

Hi all,

Hope you're doing well. I have a query about populating a source Oracle database from one server to a target Oracle database on another server. For example, a schema named "XYZ" in the source Oracle database has 100 tables. Now, I need to define a target_schema for these 100 tables. Currently, I'm manually clicking on each table and writing it. My question is, how can I automate this process by defining a global rule?

[john_wang]

Hello @sardarabdullahkhawar ,

Thanks for reaching out to Qlik Community!

There are several options to rename the schema, you are currently using tables' level transform.

You may use  Global Level rule, Defining global rules of Rename Schema.

Hope this helps.

John.

[john_wang]

Hello @sardarabdullahkhawar ,

BTW, The Tables' Level Transformation has higher priority than the Global Level Transformation. The Tables's transformation overwrites the Global transformation if their definition are different.

Regards,

John.

[Heinvandenheuvel · Accepted solution]

John is correct, but why not use the "TASK SETTNIG - 

Target Metadata

Target table schema:    XXXX

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar