In Kettle (Pentaho Data Integration), when you use a "Table Input"
component, you have to create a database connection.
In the database connection form, fill the fields of your mysql
database, and test it.
If successfull, go to Options (left tab)
In the right tab, below defaultFetchSize and useCursorFetch, add
zeroDateTimeBehavior and it's value convertToNull
Hope this helps !
Tidak ada komentar:
Posting Komentar