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

strpdsnk · 2008-05-13 20:26:09

Tags: [delimited file, java, metadata, mssql, schema, tos 2.3.3]

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.

Uploaded Images

Last edited by strpdsnk (2008-05-13 20:27:00)

shong · 2008-05-14 07:58:46

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

mhirt · 2008-05-14 17:56:44

Hello,

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

Regards,

Last edited by mhirt (2008-05-14 17:56:59)

strpdsnk · 2008-05-14 20:34:09

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.

Last edited by strpdsnk (2008-05-14 21:07:50)

strpdsnk · 2008-05-14 21:08:10

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

mhirt · 2008-05-14 21:11:59

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

strpdsnk · 2008-05-14 21:13:41

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.

strpdsnk · 2008-05-14 21:56:30

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?

shong · 2008-05-15 05:12:47

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

strpdsnk · 2008-05-15 20:54:50

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?

strpdsnk · 2008-05-15 21:10:55

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?

strpdsnk · 2008-05-15 21:54:10

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

Uploaded Images

strpdsnk · 2008-10-16 00:06:23

yay!

[Bugtracker, feature 3815, duplicate] Metadata - "Guess" Schema - guesses null length for fields with null values --> tMSSqlOutput failure
[Bugtracker, feature 3865, fixed] way to auto set default Type and Length in Metadata

Uploaded Images

ranmori · 2009-05-25 11:36:38

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

lediana0801 · 2009-06-30 03:47:59

Thanks so much for sharing the post.

credit auto

heaths · 2009-07-08 04:29:44

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

Bancato · 2009-08-05 05:50:26

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

banmark · 2009-08-17 03:02:53

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

blackberry8100 · 2009-08-18 03:26:13

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

Last edited by blackberry8100 (2009-08-18 03:27:48)

Announcement

Unanswered posts

#1 2008-05-13 20:26:09

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

#2 2008-05-14 07:58:46

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

#3 2008-05-14 17:56:44

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

#4 2008-05-14 20:34:09

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

#5 2008-05-14 21:08:10

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

#6 2008-05-14 21:11:59

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

#7 2008-05-14 21:13:41

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

#8 2008-05-14 21:56:30

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

#9 2008-05-15 05:12:47

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

#10 2008-05-15 20:54:50

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

#11 2008-05-15 21:10:55

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

#12 2008-05-15 21:54:10

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

#13 2008-10-16 00:06:23

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

#14 2009-05-25 11:36:38

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

#15 2009-06-30 03:47:59

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

#16 2009-07-08 04:29:44

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

#17 2009-08-05 05:50:26

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

#18 2009-08-17 03:02:53

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

#19 2009-08-18 03:26:13

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

Board footer