• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Read delimited file. The fields are read from the field in a database

#1 2012-04-30 17:02:44

oscarmsanz
Member
Registered: 2011-12-06
Posts: 78

Read delimited file. The fields are read from the field in a database

I use open talen studio 5.0

I have a tab-delimited file

dni: 112031
telephone: 123456894
Name: Oscar

I declare that .....
......................

Signed: Oscar Manso

In database I have a table with the name labet to read in the tab-delimited file

id tags
1 phone
2 name
3 DNII

I have to read labels database and find the labels on the field tags in the file and pick up your value. In the end I have to have a type TMAP

dni
Phone
name

After creating the job will continue to be more operations

The aim is to make it as dynamic as possible to avoid having to change the job in Talend if we add a new field or disappears one.

Best regards,
Oscar Manso

Last edited by oscarmsanz (2012-04-30 17:40:24)

Offline

#2 2012-05-02 06:18:57

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Read delimited file. The fields are read from the field in a database

Hi Oscar

It's impossible to get the schema dynamically in Talend Open Studio.
The dynamic schema is supported by Talend Integration Suite(Commercial version) as you know.
You have to change it manually.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-05-03 00:08:24

oscarmsanz
Member
Registered: 2011-12-06
Posts: 78

Re: Read delimited file. The fields are read from the field in a database

Hi Pedro

Ok, thanks.

With this I shall pass my project manager and decide if it compensates switch to the commercial version or find another product that does what they want

Regards,
Oscar Manso

Last edited by oscarmsanz (2012-05-03 00:09:06)

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Read delimited file. The fields are read from the field in a database

Board footer

Powered by FluxBB