[resolved] way to auto set default (data) Type in Metadata, or DB Type in Schema?

[Anonymous]

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.

[Anonymous]

Hello

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

Talend can't do that automatically as your said. Maybe other users don't want to set the type/DB type as varchar by default, but int.
Best regards

shong

[Anonymous · Accepted solution]

Hello,
Yopu can use your own mapping : go to Window -> Preferences -> Talend -> Metadata of Talend Types
Regards,

[Anonymous]

Is there any way to specify a default for a single job or project?
^that would work for this particular task, but might conflict with what we want to do with future jobs.

[Anonymous]

I guess I could make that change (that mhirt suggested) for this job and export it, and then revert back to the original settings for any new jobs I create...

[Anonymous]

Well, if it's only for one job, don't bother yourself.
It will be probably faster to configure your component schema manually...
Good luck

[Anonymous]

The problem is that the file the metadata is based off of is going to be changing - and we have no way of knowing, now, when and what those changes will be. Or how frequent they will be.
So, we really need this to be able to be automatically configured.

[Anonymous]

If I had a file that contained information on all possible fields, is there a way to set up a lookup to update the Type or DB Type and Length, based on the column name from the data file?

[Anonymous]

Hello

If I had a file that contained information on all possible fields, is there a way to set up a lookup to update the Type or DB Type and Length, based on the column name from the data file?

It is impossible to do that, because currently we can only define the schema on design time, not on run time.
Best regards
shong

[Anonymous]

Ok... is there some other available solution that you can think of?
If not, and I wanted to request a solution, how would I do that and what should I request to be able to do what I want to do?