Close popover
Parthasarathi Roychowdhury (PARTHA209552)
Cognizant Technology Solutions

Cognizant Technology Solutions
PARTHA209552 Member since 2011 7 posts
Cognizant Technology Solutions
Posted: April 26, 2016
Last activity: May 4, 2016

Question on Data Type Creation

There is a requirement that some user related information will be stored in a Data Type and those information will be accessed very frequently by all the users of some different applications (sibling applications). I have below questions on the creation of the Data Type:


1. The Data Type will have 4-5 columns and will contain around 60-70 records which should not increase down the line.

Now in the Records tab of the Data Type below some warning is coming:

The system could not generate a dedicated database table for this data type. Click on the link to get the SQL and ask DBA to run.


In older version of Pega we generally not used to map Data Table to a table for this many records. So the question is should we map the Data Type class to the table? But since the Data Type will be used frequently, won't there be a performance impact if we map to a table because of frequent database interactions?


2. What is the need for adding the Data Type in the Application? What will be the impact if not added?


3. We have added the Data Type in the build on Application so as per the inheritance it should appear in the Data Explorer for all the child applications (as I've mentioned the Data Type will be used by sibling applications). Do we need to add the same Data Type for each of the applications?

Data Integration
Moderation Team has archived post