Oracle Load warning

mab_arif16 · Post by **mab_arif16** » Wed Aug 23, 2006 12:04 pm

Hi
While loading the data in oracle using orale load option I got the following warning
Ora_qty: When checking operator: When validating export schema: At field "M_QTY": "null_field" length (16) must match field's fixed width 8
The feild M_QTY in target is of type float(22) and nullable ,

Can somebody let me know how to fix the warning I tried changing the coloumn in data stage to integer,tried float with length 8 but none worked out (same warning)

thumsup9 · Post by **thumsup9** » Wed Aug 23, 2006 12:31 pm

I think I am not clear here, Whats the Source Field and target field datatype and lengths

mab_arif16 · Post by **mab_arif16** » Wed Aug 23, 2006 12:42 pm

thumsup9 wrote:I think I am not clear here, Whats the Source Field and target field datatype and lengths

Both in source and target the feild type is float (22) but when import the meta data it comes as double

thumsup9 · Post by **thumsup9** » Wed Aug 23, 2006 1:18 pm

Typically this happens to us when there is mismatch in the datatype , specially Fixed width fields carrying Null Values. You can also check the below link

viewtopic.php?t=97873&highlight=When+va ... ort+schema

I know DSXchange team is working on this

mab_arif16 · Post by **mab_arif16** » Wed Aug 23, 2006 3:25 pm

thumsup9 wrote:Typically this happens to us when there is mismatch in the datatype , specially Fixed width fields carrying Null Values. You can also check the below link

viewtopic.php?t=97873&highlight=When+va ... ort+schema

I know DSXchange team is working on this

Is there any way to get rid of it

ray.wurlod · Post by **ray.wurlod** » Thu Aug 24, 2006 12:21 am

Null Field Length property is for use with variable-length strings. You do not have any of these in a fixed-width file. Use Null Field Value property instead (they are mutually exclusive), and make sure that the value is of the correct length.

mab_arif16 · Post by **mab_arif16** » Thu Aug 24, 2006 12:05 pm

ray.wurlod wrote:Null Field Length property is for use with variable-length strings. You do not have any of these in a fixed-width file. Use Null Field Value property instead (they are mutually exclusive), and make sure that the value is of the correct length.

How do you chage to Null Feild Value property I dont have any sequential file in job ,I am loading it in oracle feild of type float 22

thumsup9 · Post by **thumsup9** » Thu Aug 24, 2006 12:14 pm

You will find In Field Defaults:
Defines default properties for columns written to the file or files.
These are applied to all columns written, but can be overridden for
individual columns from the Columns tab using the Edit Column
Metadata dialog box.

Null field value. Specifies the value written to null field if the
source is set to null. Can be a number, string, or C-type literal
escape character.

mab_arif16 · Post by **mab_arif16** » Thu Aug 24, 2006 12:25 pm

thumsup9 wrote:You will find In Field Defaults:
Defines default properties for columns written to the file or files.
These are applied to all columns written, but can be overridden for
individual columns from the Columns tab using the Edit Column
Metadata dialog box.

Null field value. Specifies the value written to null field if the
source is set to null. Can be a number, string, or C-type literal
escape character.

Sorry , I think I dont have much experience with tool yet.
Can you also please tell me is feild defaults a administrator setting ,when I go to edit row in column defination for oracle stage I dont see any feild defualts

ray.wurlod · Post by **ray.wurlod** » Fri Aug 25, 2006 1:19 am

Default values are built-in. You can not prescribe different defaults. You can, of course, override defaults by setting property values.

kool78 · Post by **kool78** » Fri Aug 25, 2006 10:22 am

I belive Default Null value property is available for Sequential files but not for Oracle Stage.

Correct me if I'm wrong

kris007 · Post by **kris007** » Fri Aug 25, 2006 10:38 am

Yes, you are right.

kool78 · Post by **kool78** » Fri Aug 25, 2006 11:39 am

Thanks kris007

the problem for this topic is with oracle stage but not with sequential file stage...

from all the replies i see the answers were refering to sequential file...

hope someone replies for an oracle stage solution.....

ray.wurlod · Post by **ray.wurlod** » Fri Aug 25, 2006 10:57 pm

It's no different really, it's just that there's no property so that your design must ensure that whatever value is used to represent NULL has the same width in the fixed-width DATA file as the field.