> The teiid runtime is able to fetch transactionSchema objects. I am able to see TransactionSchemaView through a JDBC client but only metadata.No content is available. so unable to fire any query on this view.
What is your source translator?
> So how can we use object datatype and see content in this kind of views?
You can use UDFs or OBJECTTABLE OBJECTTABLE - Teiid 9.0 (draft) - Project Documentation Editor to extract whatever columns you need from the object values. There is logic built-in for this with the object/cache translators as well.
I am using a custom translator.
If you are using the custom translator, you can expose source tables with objects and then use the OBJECTTABLE as Steve mentions to extract the data. But if you want your translator to show matadata and show full relational schema, then you have write translator to expose that.
Did you take look at "Object" translator Teiid has? does it not satisfy you needs? it sounds like that would be a perfect match.