topic Re: Target Table Schema in Qlik Replicate

Target Table Schema

sardarabdullahkhawar — Sun, 31 Dec 2023 08:59:13 GMT

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?

Re: Target Table Schema

john_wang — Sun, 31 Dec 2023 09:14:25 GMT

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.

Re: Target Table Schema

john_wang — Sun, 31 Dec 2023 10:09:38 GMT

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.

Re: Target Table Schema

Heinvandenheuvel — Sun, 31 Dec 2023 17:17:33 GMT

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

Target Metadata

Target table schema: XXXX

Re: Target Table Schema

SushilKumar — Tue, 02 Jan 2024 05:13:30 GMT

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