Page 1 of 1

default values in schema file

Posted: Sun Sep 26, 2010 4:55 am
by deepthi
Hi

Iam trying to create a generic job which generates sample records using row gen or column gen stage. iam using scheme file for defining metatadata in the stages.
My problem is , i want to give defaults values for some columns. Iam not
able to define default values in the schema files. I still want to keep this job generic

Thanks for your suggestions

Deepthi

Posted: Sun Sep 26, 2010 2:52 pm
by ray.wurlod
Experiment. Add one or more default values in a job, save the table definition, then open the table definition and use the Layout tab to inspect the record schema. Please let us know the answer.

Posted: Mon Sep 27, 2010 5:41 am
by GJ_Stage
Try this:

Without Default value

FIELD_NAME:nullable string[4] {null_field=' '}

With Default value

FIELD_NAME:nullable string[4] {default='test', null_field=' '}

Posted: Thu Sep 30, 2010 12:56 am
by deepthi
I have tried both of the options above. But no luck yet.

Any more clues?