Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

How to achieve Synonym switch(switching reference of one table to another table).

Avatar

Level 2

My requirement is An import data from a workflow to update real-time data to the campaign tables, scheduled for  Daily execution. The data expectation would be more than a million records. for this a down time of 30 min is expecting as per the test. so i need a solution to reduce that down time to ZERO min.

As a part of identifying solutions, I come across the switching tables.

To be specific:

offline data and online data.

In offline, data will be loaded to one table  say "customer".{another table which is already online with the same fields of "customer" table say "customer_backup"}

so i need to switch from customer_backup table to cusotmer table to be online so that the delay is skipped as the table is already loaded just need to switch.

 

Suggest me the activities, sql code activity usage, and any workflow to achieve this.

 

Thanks in Advance!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

Probably best to accomplish this directly with the RDBMS, using synonyms or table rename.

It can also be done with Adobe Campaign schemas, i.e. sqltable attribute if that's not allowed.

 

Thanks,

-Jon

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

 

Probably best to accomplish this directly with the RDBMS, using synonyms or table rename.

It can also be done with Adobe Campaign schemas, i.e. sqltable attribute if that's not allowed.

 

Thanks,

-Jon