There is not a great built-in story here.  Since you can directly set the cardinality via DDL create table statements, you can use both a dynamic import (where you would exclude anything you were explicitly creating) and DDL together by specifying multiple metadata repositories. 

Or once the vdb is loaded (which you could use https://issues.jboss.org/browse/TEIID-2182 to get the event) you can issue setTableStats procedure calls - https://docs.jboss.org/author/display/TEIID/System+Procedures

Alternatively you can use a custom MetadataRepository to modify your metadata as it is loaded.

An enhancement would be to allow the sysadmin metadata procedures (or functionally equivalent statements) to be called in DDL which would simply this scenario.

Steve

1) DDL and import intermixed:

{code}
<model visible = "true" type = "PHYSICAL" name = "portfolio">
         <metadata type = "NATIVE,DDL"><![CDATA[
              CREATE FOREIGN TABLE stock (
                symbol varchar,
                price decimal
                ) OPTIONS (CARDINALITY 10000);
         ]]>
         </metadata>
    </model>
{code}

Note the metadata type specifies both NATIVE and DDL.

2) See https://docs.jboss.org/author/display/TEIID/Custom+Metadata+Repository for using a custom repository.  The metadata element would look similar to the above and could be chained in the same way as to mix the different metadata types.

3) There isn't an enhancement request for this yet, but it is generally useful for the dynamic case.

Steve

Yes, go ahead and log an enhancement.

Thanks,

Steve

I believe this JIRA https://issues.jboss.org/browse/TEIID-992 was exactly created for that. It is in my bucket for long time. May be this good time to discuss how we want this implemented. If we provide some DDL constructs that would be helpful, like

ALTER TABLE/VIEW ... ADD OPTION CARDINALITY 10000

Ramesh..

You should create a new issue or a sub-issue of TEIID-992 specifically for this case.  TEIID-992 is pretty general and encompasses other aspects of updating (mostly automated) stats.

Steve