1 of 1 people found this helpful
The exact usecase as you define, no you can not do that. However there may be other options available. Can you explain your usecase in detail, so that we can see if there any other options available in Teiid.
You would use a view to encapsulate the details of a query from a client. That is not yet possible with dynamic vdbs, which is what Ramesh is indicating. But you can use Teiid Designer to create a full virtual database containing whatever view layers you may need to abstract the access details.
Teiid designer made things much more clear and the view models will work for me, thanks a lot.