Formatted length of fields and record

singhald · Post by **singhald** » Mon Aug 25, 2008 3:16 am

Hi All,

I am loading records into database table using oracle enterprise stage with sql load options.

This datasatge job was not issuing any warning messages in the director log. today it started issuing a warning messages

"EmpLoadJob: When checking operator: Formatted length of fields and record (425) less than declared length (426)"

I have searched for this topic in all fourm but didnt get any satisfactory resolution.

Please tell me if somebody have faced and resolve this issue.

Regards,

ray.wurlod · Post by **ray.wurlod** » Mon Aug 25, 2008 4:06 am

The problem is between the keyboard and the chair. You have declared a record length of 426, and a set of column widths that total 425.

The "solution" is to get it right.

singhald · Post by **singhald** » Mon Aug 25, 2008 4:20 am

Ray, Thanks for quick response,

I have not column defined 426 in terget and no column defined 425 in the source dataset.

i am not able to figure out why this warning messages is coming.

Regards

ray.wurlod · Post by **ray.wurlod** » Mon Aug 25, 2008 5:09 am

Post your record schema.