This content has been marked as final. Show 7 replies
Assuming your are following this tutorial https://blogs.oracle.com/warehousebuilder/entry/odi_11g_simple_flexible_powerful :
You don't need to drag anything in your interface.
Just right click on +<Temporary Target Datastore>+ on the right side and give a name to your datastore (in the Property Inspector).
Then add columns (right click on the name of your datastore on the right side) and define their names and datatype (in the Property Inspector) and also set the execution on the Target.
For the mapping of each column, set only --* (comment).
Then click on the flow tab, choose your KM and enter your SQL code in the option field :).
Hope it helps.
PS : I suggest you to replace getUserExit by getOption. getUserExit is deprecated.
Yes ...i am following this.
BUt i am getting the error while right click and see the data in target datastore
See com.borland.dx.dataset.DataSetException error code: BASE+62
com.borland.dx.dataset.DataSetException: Execution of query failed.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
In this tutorial, the yellow interface is use as a subselect. This means that it is not really created in the DB, but is used as a view in another interface.
So you've to build the interface that will use this yellow interface as source. You can drag and drop the yellow interface, and check the "Use Temporary Interface as Derived Table (Sub-Select)" option.