[resolved] way to auto set default (data) Type in Metadata, or DB Type in Schema?
is there a way to have Talend automatically set the Type or DB Type to a default Type or DB Type, and also Length?
basically, I want all the columns to be set to DB Type = VARCHAR and Length = 255
I know I could do this manually, but the metadata file is subject to change (it is certain that we will be adding and removing columns from this file, more than once) and I don't want to have to manually change all of the Types or DB Types and Lengths every time I update the metadata.
What about if I made a generic schema that included all possible columns and had the Types and Lengths set up like I want them to be, is there a way to have a job reference that schema and pull out the information from that generic schema and apply it to the columns that are actually in the data file being called?
Or could some option be added to the schema creation/edit screen that, if filled in, would override the standard settings? (see attached pics)
kinda like what I suggested in
viewtopic.php?pid=11532 for default null values