DSXchange

HI all,

when i run the job from oracle entraprise stage to oracle enter prisse stage inbetween using with transformer stage.
when it was declared like in source stage
method: table read
autogeneration
11 colummns in table in oracle , but here it has declared in the stage just 5 columns.
its giving the primary key of the table in oracle(from 11 columns) not mentioned in this 5 columns.
but it was giving the error that primary key column "scale length has not been loaded".

RT_SC609/OshExecuter.sh: line 20: 11983 Segmentation fault (core dumped) $APT_ORCHHOME/bin/osh "$@" 2>&1

Scale is the second piece of a Decimal number, which is specified as Decimal(precision,scale). You will find Scale in the Columns grid of the table definition. If this needs to be 0, put 0 in there explicitly, because the error message is complaining that there's no value there.