-
1. Re: Challenge while creating single View for two Sources
rareddy Apr 24, 2014 8:35 AM (in response to madhurika_sharma)1 of 1 people found this helpfulMadhurika,
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.
Ramesh..
-
2. Re: Challenge while creating single View for two Sources
madhurika_sharma Apr 24, 2014 10:06 AM (in response to rareddy)Ramesh,
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?
-
3. Re: Challenge while creating single View for two Sources
rareddy Apr 24, 2014 10:16 AM (in response to madhurika_sharma)Madhurika,
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.
See http://teiiddesigner.jboss.org/docs
See Quick Starts - Teiid Examples - Project Documentation Editor
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.
Ramesh..