You are not logged in.
I have an ODBC connection set up to Oracle. This connection can be used by Excel to retrieve data with no problem. However, when I attempt to use the tDBInput connection in Talend, my data is truncated. For example, I have the following columns with the Oracle datatypes:
CurrentPeriod - char(6)
CurrentProductYear - char(6)
ProductCode - char(5)
I set these to "character" types in TOS (ver 2.2.0GA_r6191). When I run the query, I get these results from tLogRow:
The data appears to be truncated. I have tried both "String" and "Character" types in Talend and changed the length settings in the schema. Any ideas on this?
Thanks - headjoog