Not able to update data from ODI
494659Oct 1 2007 — edited Oct 3 2007Hello Techies,
I am pretty new to ODI and need help on one of the issues I am facing.
I have a model with MySQL as the data source and I am required to right-click -> Data -> update a particular row.
When I do this I am getting following error :
Data set has no unique identified.
Note : For queryDataSets you need to disable metadataUpdate.ROWID in the MetaDataUpdate property, in addition to setting the Rowid property on a column.
Immediate help will be highly appreciated.
Thanks,
Rishi