topic Re: [resolved] way to auto set default (data) Type in Metadata, or DB Type in Schema? in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 14:22:28 GMT

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.

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

Anonymous — Wed, 14 May 2008 06:58:46 GMT

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

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

Anonymous — Wed, 14 May 2008 16:56:44 GMT

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

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

Anonymous — Wed, 14 May 2008 19:34:09 GMT

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.

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

Anonymous — Wed, 14 May 2008 20:08:10 GMT

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...

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

Anonymous — Wed, 14 May 2008 20:11:59 GMT

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

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

Anonymous — Wed, 14 May 2008 20:13:41 GMT

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.

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

Anonymous — Wed, 14 May 2008 20:56:30 GMT

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?

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

Anonymous — Thu, 15 May 2008 04:12:47 GMT

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

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

Anonymous — Thu, 15 May 2008 19:54:50 GMT

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?

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

Anonymous — Thu, 15 May 2008 20:10:55 GMT

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?

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

Anonymous — Thu, 15 May 2008 20:54:10 GMT

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

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

Anonymous — Wed, 15 Oct 2008 23:06:23 GMT

yay!
3815
3865

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

Anonymous — Mon, 25 May 2009 10:36:38 GMT

simulation credit auto
It's really great. I like it very much.
Thanks strpdsnk so much ^^

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

_AnonymousUser — Tue, 30 Jun 2009 02:47:59 GMT

Thanks so much for sharing the post.

credit auto

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

_AnonymousUser — Wed, 08 Jul 2009 03:29:44 GMT

Thanks for sharing your idea here. I appreciate your idea, very excellent.
simulationcredit

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

Anonymous — Wed, 05 Aug 2009 04:50:26 GMT

That's quite a very interesting but difficult work.
proprietaire simulation rachat credit immobilier consommation - demander un rachat de crédit, faites une simulation rachat de credit en ligne. proprietaire simulation rachat credit immobilier consommation

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

Anonymous — Mon, 17 Aug 2009 02:02:53 GMT

is there some other available solution that you can think of?
proprietaire simulation rachat credit immobilier consommation - demander un rachat de crédit, faites une simulation rachat de credit en ligne. proprietaire simulation rachat credit immobilier consommation

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

Anonymous — Tue, 18 Aug 2009 02:26:13 GMT

Marked! I will check it later!thanks a lot.
simulation taux banque credit immobilier de France - Credit immobilier de France, simulation credit immobilier. Résultat mitigé pour le crédit immobilier de France. simulation taux banque credit immobilier de France