1 of 1 people found this helpful
On your view Test, you need to edit the transformation for insert and add your own such that you are only inserting into "OneTable" and not "Combined". Also why do you need to keep the combined in your view "Test" if all the column names are same. You can either remove all the duplicate names from the "Test" and leave only unique names, there is no restriction that you got to include all the columns from both "OneTable" and "Combined".
Also, full stack-trace is needed for us to see what is error you are seeing.
If i delete duplicate columns , how can i be sure that the data inserted goes into either tables underneath view(Combined) or to the table(ABC).What kind of transformation are u talking about?
Have you gone through any quick start examples in Teiid? I suggest you going through and learning how Teiid works first, then you can delve into your usecase with much more ease.
These will give you better idea how it works, and how you can import and create views in the Teiid.
BTW, if your view in the source "Combined" does not support insert, then Teiid can not help to insert through that view, you need to write SQL code in the Teiid's View (Test) to insert into underlying tables of "Combined" directly.