3 Replies Latest reply on Dec 14, 2010 10:57 AM by Ramesh Reddy

    Designer - Two tables in the same View Model?

    colo Newbie

      Hi,

       

      I added two table bases on a model view (using Teiid Designer) and I can only see one of them when I execute querys.

      Both base tables have a transformation from the same source model, in one of them I see some columns and in the second, other columns.

      Have any idea of the reason?

       

      Regards

      Nicolás

       

      Sorry, now it's works normally, I don't know what happened...
      Anyway thanks very much!

       

      Sorry, now it's works normally, I don't know what happened...

      Anyway thanks very much!

        • 1. Re: Designer - Two tables in the same View Model?
          Ramesh Reddy Master

          That sounds strange. You can add any number of tables to a model. Model == Schema, a Schema can contain any number of the tables, views and stored procedures. If you want attach the VDB and I will take a look what is going on with it.

           

          Thanks


          Ramesh..

          • 2. Re: Designer - Two tables in the same View Model?
            colo Newbie

            Once the VDB is running, if we make changes, how we should proceed to take account of these changes?

            Because that is the problem, the machine is not updated...

            I tried to execute Undeployed, also disconnect from the database, refresh the project, close it and download the server, but do not know the effective way.

             

            Thanks very much

             

            Regards

            Nicolás

            • 3. Re: Designer - Two tables in the same View Model?
              Ramesh Reddy Master

              Nicolas,

               

              One thing to note in Designer is it provides you with two different options for testing.

               

              1) Preview - Used during the design time of your models, using this you can check the results on single view or procedure. Click the "running man" icon for this once you select the view/table.

               

              2) VDB Execution - Once you are done with modeling (multiple models), you bundle them into VDB, then you can test as whole. In this scenario, you need to explicitly deploy/undeploy the VDB, to see the modifications.

               

              Hope above helps.

               

              Ramesh..