problem with paralle direct load

[mehimadri123]

Hello,

I am facing a problem while loading data with oracle enterprise stage using parallel direct load method.

I have indexes created on that table, and am using the index mode as rebuild. The problem is with a column with data type decimal(6,3).

while loading from source it is ok, but while loading into target it makes the column 0 for some values.

For instance, for input value 11 for that column, the value loaded into target is 11. But for input value 1 for that column, the value loaded is 0.

any help!!

[us1aslam1us]

Did you try using peek or flat file as output to test? I really doubt that there might be some tranformations which is causing this issue. Share you Job Design...