topic schema default values in Talend Studio

schema default values

Anonymous — Sat, 16 Nov 2024 13:13:50 GMT

Hi
Under what conditions can I use the schema default values?
Here's what I have done so far:
tRowGenerator: int and string variables
tmap: same fields out, but set the values to null.
In my tFileOutputDelimited I have set the default values to "10" and "default".
This doesn't pick up the defaults.
I have also tried to set the fields to nullable and non-nullable, I have tried to set the expressions in tMap to blank and have also set the values to 0 and "" but none of these pick up the defaults.
I know that I can use the ternary operator to test for null and set a default, but I just want to find out if the default schema values do work and when?
Thanks
Rick

Re: schema default values

Anonymous — Sun, 31 Oct 2010 08:42:20 GMT

hi,
you have to put default value into the input flow field "default".
trowgenerator don't generate a null value so do your test for example with tfixedflowInput.

but effectivly you cannot affect data with a default value into output row except with some filter or ternary method!
It sound a normal behavior ... change data with some default value when you write it, it's like prepare all your stuffs for "winter holidays" and drive to "miami beach" (bad comparison's permited on Sunday !!!)
But one thing about those "null value" ... even (unfortunatly) if you have null value into your String field (!!!) with a rule "not nullable" you are able to write into some file without any alert or warning ....(see https://community.talend.com/t5/Archive/string-to-bigdecimal-conversion-error/td-p/175475 )
So manage your "possible" null value in all cases .
hope it enlighten you
regards
laurent

Re: schema default values

Anonymous — Mon, 01 Nov 2010 08:26:18 GMT

Thanks kzone,
Just to clafiry, the defaults are applied if a null is present in a non-nullable input, is that correct?
So does this apply to all input components?
Regards,
Rick