Datastage warning
Posted: Wed May 03, 2006 10:06 am
I have read through previous posts for this but I don't understand why I am getting this warning.
I have a job,
sequential file->surrogate key generator -> Oracle Enterprise.
In the sequential file I have 2 fields relationship_code and relationship_description, In the surrogate key stage I define a field called rela_key which is an integer.
When I run the job I get the following warnings:
Oracle_Enterprise_1: When checking operator: When validating export schema: At field "RELA_KEY": "null_field" length (0) must match field's fixed width (40)
Oracle_Enterprise_1: When checking operator: When validating export schema: At field "RELA_KEY": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field
Thanks
I have a job,
sequential file->surrogate key generator -> Oracle Enterprise.
In the sequential file I have 2 fields relationship_code and relationship_description, In the surrogate key stage I define a field called rela_key which is an integer.
When I run the job I get the following warnings:
Oracle_Enterprise_1: When checking operator: When validating export schema: At field "RELA_KEY": "null_field" length (0) must match field's fixed width (40)
Oracle_Enterprise_1: When checking operator: When validating export schema: At field "RELA_KEY": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field
Thanks