ETL and Data Integration tools - Modern ETL software for everyone

VI Pro version 7.7.6.3
Repository Type .mdb
Import of data from Oracle 10.2.0.4 to Oracle 10.2.1.1
Source Table has a date column that is null. In VI tool grid view, column is null. Using a SELECT * FROM TableA as query.
After successful import from OraA.TableA to OraB.TableA, date column that should have null date has a date.

David

David

Can you email us a screen shot so we can see the source data and the mapping you used

Also what are your connections settings for oracle

Eg do you use oracle connection/odbc/oledb

Direct path loading or conventional?


Mike

Oracle/SQL connection is OLEDB and both source and destination tables have Unique Key.

thanks

This was resolved in version 7.7.6.6

Mike

Import of arbitrary date where should be null has been corrected.

Great job again – thanks.