Default value in column

[Nagac]

Hi

I want to create new column with default value using column generator stage using schema file. i tried with below schema file, but it has not created with default value( i gave in the schema). It has incremented by 1 starts with 0.

Code: Select all

record
(
  Number:decimal[5,2] {default=000.00};
  )

Could someone face this issues, please help me.

Here we should not use Transfomer stage as i am using RCP.

Thanks

[ray.wurlod]

Try it with no space between the "]" and the "{".

[Nagac]

Try it with no space between the "]" and the "{".

Thanks Ray,

But still i am getting the same warning message and same data incrementing with 1.

Code: Select all

Column_Generator_12: Field Number  of type decimal[5,2]:: unrecognized generator parameters ignored:  

.

I thought of generating this field in Column Import stage while importing the single field to multiple fields but It doesn't support to create new field which doesn't exist in source.

[ray.wurlod]

Build a table definition and view its parallel layout to get the correct syntax.

[Nagac]

Thanks Ray.
Correct One

record
(
Number:decimal[5,2] {cycle={init=000.00, incr=0}}
)