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

 Alagar Pandi Pandi (MayanAlagar)
Wirpo Technologies
Alagar Pandi Pandi
Wirpo Technologies
AU
MayanAlagar Member since 2010 41 posts
Wirpo Technologies
Posted: May 26, 2016
Last activity: May 26, 2016
Posted: 26 May 2016 0:12 EDT
Last activity: 26 May 2016 6:35 EDT
Closed

Merge Database table into single table impact ?

Hi,

We have

Org-A-Work map to table X

Org-B-Work map to table Y

Org-C-Work map to table Z

What will happened when map all class to table X.

We taken care about manual sql used in RDb if table hardcoded. If there is key/column constraint there in all three tables, we ll merge it to table X.

Does it create any problem in Report/Agent/SLA processing.

Thanks

Alagar

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 26 May 2016 6:35 EDT
Swati Damele (dames)
Tetrasoft India Private Limited
Module Lead
Tetrasoft India Private Limited
IN

Hi,

Do we have all the classes belonging to same class group?

If yes, then we can have a common Database table.

Otherwise, how will the primary key for each be used?

Therefore, in my opinion if they do not belong to same class group, we should create separate tables for each class.

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