Read and Write Limitations - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

Read limitations

  • Spectrum Discovery does not interpret case-sensitive field names as different names. If two tables or column names use the same name but different cases, they are interpreted as duplicate names. If a model store contains such field names, the deployment of that model store fails.

    For example, fields like DeDup, Dedup, and DEdup are interpreted as duplicate names. The deployment of a model store containing such case-differentiated fields fails.

  • If a Data Source, physical model, logical model or model store has a dependency on a JDBC-specific data source, it cannot be imported or exported using the Administration Utility.

Write limitations

While writing to a database source using the Write to DB stage in Enterprise Designer, there are certain limitations.

  • Creation of tables while writing to a database source using a Spectrum Discovery connection is not supported. If you click Create Table while using a Spectrum Discovery connection, a runtime exception is displayed.
  • Spectrum Discovery does not support unified writes to multiple connections simultaneously. You can write to a single source at a time.
  • Dropping and recreating any table while writing to a database using a Spectrum Discovery connection is not supported.
  • Delete and truncate operations are not supported while writing to a database using Spectrum Discovery. Only insert and update operations are supported.
  • Spectrum Discovery performs a commit after completion of each batch insert. The Batch count to commit cannot be changed to any other value other than 1.
    In the Runtime tab of the Write to DB stage in Enterprise Designer, the Batch count to commit field can only have the value 1 for Spectrum Discovery.
    Note: A batch consists of 1000 records by default. You can configure the batch size according to your system, in the Runtime tab of the Write to DB stage in Enterprise Designer.
  • For batch inserts, the feature Commit at the end is not supported. This feature refers to performing a commit after all batches are complete. In Spectrum Discovery, a commit is performed at the end of each batch insert completion.