Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Level 1
Hari_07
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
Hari_07
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
Hari_07
Level 1

07-06-2021

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!

View Entire Topic

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

07-06-2021

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