Could you give me a hand

[robin622091]

Could you tell me how can I limit the data in VDB? I have built up a *.xmi file and needs to build up three VDBs according to this xmi file. The entries in each VDB is different from others. How can I implement this requirement using Teiid Designer? Thanks a lot.

[rareddy]

Wei,

Not sure what your question is? *.xmi files are in the Teiid Designer and they are model files that provide metadata to form the VDB. In other words they provide the schema details of the VDB, and has nothing to do with the data. To limit the data from your queries, you can use LIMIT clause like

{code:lang=SQL}

Select * from Customer LIMIT 10;

{code}

Ramesh..