Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

jcoutin
2008-09-17 15:05:34

You can dynamically change the name : put a context variable in "file name" field.

You can also use "export as context" in the Metadata repository.

tcimoli
2008-09-17 14:48:16

>You can change the file name in the job.
i have to do it, dinamically. I will not runn all jobs by hands. Is there a way to change   job properties at runtime?

Anyway: i have to reuse schema definition a lot in different components. i do not want to edit manually each time, i would like to define it once. Is it possible?

jcoutin
2008-09-17 14:22:23

Hello,

1) You can change the file name in the job. (File Name in Component properties).

2) I guess creating a  metadata file takes a long time because talend read the file to determine field type (String, Integer etc...)

JC

tcimoli
2008-09-17 13:43:03

I have some Excel files to migrate, which have same structure (i.e column name, column order)
In TOS i would like to create a metadata for that schema, but without linking it to a specific file: the file will change, but the schema will be the same.

What i have to do so far is to create a new Metadata-> File Excel, but in this case i can only use that schema on that file.

i have two questions:
1)  Is it possible to define generic schemas for excel files?

2) Creating a metadata file takes a long time before ending (7/ 10 minutes).  The Excel file is about 15Mb.

Why does it takes so much time? i only need it to load the schema of the file. It is not necessary that it reads all the file.

Maybe i do not know the meaning of Metadata for files: does it keep in RAM all the file to be quicker when running job?

Board footer

Powered by FluxBB