Helpful hints and information

  • • No “singleton” rows are allowed in the Data Lake which means there cannot be a separate table for status and permission. The fields in these details are part of the header table.
  • The FSDOC and FSDECRIPTION tables are shared between different symbols in an Optiva database. In the Data Lake, they are separate tables by symbol (for example OPTIVA_FSITEMDOC, OPTIVA_FSITEMDESCRIPTION).
  • The Data Lake functionality uses the Inbox Listener to schedule the workflow that sends data to the Data Lake therefore, the listener must be running for the functionality to work properly.