You may need to set the StringColumnLength connection parameter to a higher value. see ERROR: "Informatica ODBC 10170 String data right truncation on data from data source: String data is too big for the driver's data buffer" while running the session with PowerExchange for Cassandra for Cassandra Target in PowerCenter. It appears to be an ODBC driver issue not a DBI one imo