Skip to main content Link Menu Expand (external link) Document Search Copy Copied

DB Connector Not Auto Generate SQL

Summary

Identifies Connections that do not use Auto Generate SQL.

Description

In InfoSphere Information Governance Catalog, the schema and database table name of the imported database must be the same as the schema and database table name in the stage.

You can generate default SQL statements to read from and write to data sources. Alternatively, you can specify SQL statements manually that read from and write to data sources.
SQL that you specify might contain certain DBMS-vendor-specific constructs that cannot be parsed correctly in job lineage analysis.

As a result, the relationships between stages and data sources and between stages and other stages might be incorrect.

Actions

Update the connector to use Auto Generate SQL.


Back to top

Copyright © 2017-2024 Data Migrators Pty Ltd.