DSXchange

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)

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

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

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

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

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.

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

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.

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

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

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

Correct me if I'm wrong

Yes, you are right.

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.....

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.