Designer - Two tables in the same View Model?

[colo]

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!

[rareddy]

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

[colo]

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

[rareddy]

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