1 Reply Latest reply on Jul 16, 2013 8:02 AM by Ramesh Reddy

    Could you give me a hand

    wei zhao Newbie

      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.

        • 1. Re: Could you give me a hand
          Ramesh Reddy Master

          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..