Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 krishnaveni m (krishnavenim3707)
virtusa

virtusa
IN
krishnavenim3707 Member since 2015 4 posts
virtusa
Posted: Sep 27, 2018
Last activity: Sep 27, 2018
Posted: 27 Sep 2018 4:22 EDT
Last activity: 27 Sep 2018 10:05 EDT
Closed

Map WORK and History tables to new tables

Hi Team,

My application is currently in Production and facing performance issues. As per suggestion, we need to map WORK and History tables to new tables. Till now they are mapped to default PC_WORK and PC_HISTROTY tables. these table have 1 millions records and they should not be archived.

As per suggestion, I have created new tables. Here my question is if I map the work ad history classes to new tables. How can I transfer records from old table to the newly created ones and Do I need to take any other precautions before mapping to new tables. Please let me know.

***Edited by Moderator: Pallavi to update platform capability tags***

To see attachments, please log in.
Data Integration
System Administration

Posted: 6 years ago
Posted: 27 Sep 2018 10:05 EDT
Bhavya Tyagi (Bhavya)
Coforge DPA
Senior Technical Lead
Coforge DPA
GB

Hi

In this case, you can take help of your DBA to copy the data between tables. That will be the quickest way to do this. Make sure the schema is same.

Just to confirm,  the class name is still same  and you have just changed the mapping to the new table.

Regards

Bhavya

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice