Staging Column Details

The database table used for staging the actual data is EIS_STAGINGTABLE, which is generic and has only string type columns as the data is not typed at this point. The table comes with 100 columns of varying sizes by default. For the provided application and data services properties are mapped through translations to specific columns. The size of the default columns is provided below:
  • COL1-COL2 = 4000
  • COL3-COL5 = 1024
  • COL6 -COL30 = 400
  • COL31-COL100 = 100

The sizes of the columns can be changed to meet the requirement of the data being used within the constraints of the database technology in use. In addition, additional columns can also be added to the table and mapped to new or existing properties that require staging. The EISSTG entries within the Generalized Name Translations that map Business Data Definition properties to staging columns can be updated to point properties to a larger column, where the data exceeds the current column size.