Truncating Numeric in SQL Script Parameter
My transformation has a step that issues an update via a SQL Script step. The reason I don't use an Update step is because I use a function-based lookup. Anyhow, when my numeric(11,8) is used as a parameter it is truncated to the one-tenths digit. Here is a row-level output:
DEBUG 22-08 15:08:49,882 (LogWriter.javarintln:405) -Execute SQL script.0 - Executing SQL script:
lat = ?,
lon = ?,
dlu = '?'
upper(address) = '?'
and zip = ?
INFO 22-08 15:08:49,882 (LogWriter.javarintln:406) -Postgres Superuser - launch DDL statement:
lat = 37.7,
lon = -85.5,
dlu = '2008/08/22 15:08:49.101'
upper(address) = '109 Elm Drive'
and zip = 43051
The lat and lon fields should be [ 37.882556], [-84.575698]
I have an Insert step further down the transformation that inserts the entire number correctly.