Description

Sometimes, additional data columns are added to a database table and must be reflected within the existing Domain for a Project. 

For example, two columns have been added to a User table: phone_number and user_dob. These columns must also be added to the existing Domain within the GenRocket Project. This can be done using Scratch Pad. 

How to Add New Table Columns as Attributes

• Select Scratch Pad from the New Domain menu.
  
  
  
• Enter the existing Domain name as it is in GenRocket. For example, if the table name is "user," the Domain name would be "User." An error will occur if you try to enter the table name itself.
  
  
• Select a delimiter and enter the new column names as Attribute(s). Enter the column names as they are in the database. 
  • For example, phone_number (table column) becomes phoneNumber (Attribute) in the GenRocket Domain.
    
    
• Click on Create with Generators to have the data warehouse automatically assign a Generator.
  
  
  Note: You can use the Create without Generators option if you prefer to assign the Generators yourself.
  
  
• Click Save.
  
  
  
• You can select one or more Attributes and do the following: 
  • Use the Set Generator option to assign a different Generator to the selected Attributes. 
  • Use the Modify Generator Parameters option to make changes to Generator Parameters for the selected Attributes.
    
    
    Note: To see the complete steps, please take a look at this article: How do I use Scratch Pad to quickly create a Domain?
    
    
• Click Close once finished.
  
  
  
  
• The added Attributes will appear as shown below.
  
  
  
  
• The actual table name will appear in the Orginal Name parameter for the Attribute.