Analytics Software

If anyone has any insight into this, I would really appreciate it.

I'm trying to build an incredibly simple Interface that mirrors a small MS SQL Server table into and Oracle table. The source MS table is a series of int, smallint, numeric, datetime and nvarchar columns. Similiarly, I've built my Oracle target table to be comprised of corresponding number, date and varchar2 columns.

The issue is that my Interface runs just fine, but only the date and number-related columns actually come across. All the columns that are loading nvarchar->varchar2 are simply populated with nulls.

I can't seem to figure out what the problem that ODI is having. There are no errors during execution, and back in Designer I can even do a "View Data" on the source MS table, and can browser all the data just fine.

Something is happening during transit and I can't figure out why. My current LKM is "LKM SQL to Oracle" though I've also tried "LKM SQL to SQL" with no luck. Clearly something is happening with the nvarchar to varchar2 conversion, but that seems like a ridiculous thing for ODI to have a problem with. Even moreso that's it not actually throwing any errors, but simply not populating them.

Anyone have any thoughts?

Thanks
John