This content has been marked as final. Show 2 replies
As far as I know, it is not possible to replace a DB table from ODI.
The only the features are :
- Reverse-Engineering : Retrieve the metadata from DB Table to build an ODI Datastore. You can update your ODI datastore by running it again but only new columns would be added. (So if you remove a column from your DB table and reverse-engineer the table, the column will NOT be removed from your datastore)
- With most of KMs, you can create a DB table by setting "Create Target Table" to true in your interface's flow tab.
Hope it helps,
If you are able to create an empty "dummy" schema in your database, then point your Model to that schema, you should be able to achieve the code you want using the Generate DDL functionality. A workaround, but it gets results.