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,