Document Schema
|
Identify an external schema (.xsd)
or DTD that you can use to validate the XML source.
|
Namespace Schema
|
Point to the location of an external
namespace schema. An XML schema consists of components such as type definitions
and element declarations that you can use to assess the validity
of well-formed element and attribute information items.
|
Validate Schema
|
Enable schema and DTD validation.
|
XML Options
|
Full schema check – set to 1 to check for items that may be time consuming or memory
intensive. Particle unique attribution constraint checking and particle
derivation restriction checking are controlled by this option. The
default value is 0.
Ignore external DTD – set to
1 to ignore an external DTD referenced within the document. The default
value is 0.
Process namespace – set to 0
to not consider namespace specification during
parsing. The default value is 1.
Preserve Element whitespace – set to 1 to preserve white space in the XML element value. Set
to 0 to trim white space from the XML element values. If the XML
element value includes only white space and the value is set to
0, it is interpreted as an empty element value.
|
DB Schema
|
Select the database schema setup (create
tables) script. Use this option to enforce a fixed data model.
|
DB Schema Options
|
Customize the settings for tables and
attributes generated from the XML structure, including the prefixes
for table and attribute names. The DB Schema options are: Attribute name case – formats the attribute
names generated from the XML. The values “upper” and “lower” convert
attributes names accordingly. “Mixed” (the default)
leaves the names as they appear in the XML document.
Attribute name prefix – prefix for every generated attribute name.
Create indexes – set to1 (the default)
to automatically generate indexes on the primary keys of the tables.
Create flat views – set to1 (the default)
to automatically generate a view called V_XML_CONTENT.
This view joins all tables and returns all XML data in a broad table.
If the database schema results in more than 32 tables, this view
does not work and the option has to be switched off.
Foreign key prefix – prefix for attributes that are foreign keys.
Ignore Empty Leaf Element Values – set
to 1 to not include column
entries for specific XML leaf elements that contain no data. If
set to 0, the database created from the XML document includes column
entries for all XML leaf elements whether empty or not.
Primary key name – attribute name to be
used for primary keys.
Table name case– formats the table names
generated from the xml. The values “upper” and “lower” convert
the table names accordingly. “Mixed” leaves the
names as they appear in the XML document.
Table name prefix – prefix to be used for
generated table names
|
Database Options
|
Set options that override performance
defaults and control the behavior of some transactions.
|
Read Block Size
|
Determine the number of records retrieved
by the component in a single step.
If the component has more than
one output port, the read block size is ignored and the component provides
data at all ports, in a single step.
|