> Please help in this matter. Your any kind of cooperation will be highly appreciated.
The current built-in logic supports one DDL per model - see DDL-FILE Metadata Repositories - Teiid 8.10 (draft) - Project Documentation Editor
See Dynamic VDBs - Teiid 8.10 (draft) - Project Documentation Editor, in "VDB Zip Deployment". Essentially you need to do
<model name="schema1"> <metadata type="DDL-FILE">/ddl/schema1.ddl</metadata> </model> <model name="schema2"> <metadata type="DDL-FILE">/ddl/schema2.ddl</metadata> </model>
inside the VDB. Unfortunately, you can define only one DDL file per schema right now. So, unless each of your view is in different models the above will not work correctly. We can make small enhancement to allow comma separated list of files for single schema, if you want can log an enhancement request for it.