Details
-
Bug
-
Resolution: Done
-
Blocker
-
11.0.1
-
None
-
None
Description
Prieview VDB doesn't include name in source for column. When you try to do a preview for SHIP_VIA table from partsSourceSQLServer model that is in attached project, the generated dynamic VDB looks like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="PREVIEW-21b09376-8753-42ac-a874-34d47820fc30" version="1"> <description>Importer VDB</description> <property name="UseConnectorMetadata" value="true" /> <property name="deployment-name" value="PREVIEW-21b09376-8753-42ac-a874-34d47820fc30-vdb.xml" /> <model name="partsSourceSQLServer" type="PHYSICAL" visible="true"> <source name="partsSourceSQLServer" translator-name="sqlserver" connection-jndi-name="java:/partsSourceSQLServer" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE SHIP_VIA ( SHIPPER_ID bigdecimal NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), SHIPPER_NAME string(30), AVERAGE_TIME_DELIVERY bigdecimal OPTIONS(FIXED_LENGTH 'TRUE'), CONSTRAINT PK_SHIP_VIA PRIMARY KEY(SHIPPER_ID) ) OPTIONS(UPDATABLE 'TRUE'); ]]></metadata> </model> </vdb>
It is missing name in source for AVERAGE_TIME_DELIVERY (which is "AVERAGE TIME DELIVERY" at it is defined in the XMI model). Preview cannot be done.
