• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » changing the values of table and column names at job run time

#1 2008-12-03 12:26:47

Swami
Guest

changing the values of table and column names at job run time

Hi,

We have created a set of flows(jobs) which uses sysbae tables as source and db2 tables as target.
Is it possible to parametrize(mark as variables) the source table name and column names so that the actual values for  table name and column names can be set before the job execution.

We have requirement where the actual source server name, source database name,the source table name and column names is not known while building the job in the open studio.

These needs to be set after the job is exported from the open studio and at the time when they are executed.

The source database type is fixed, that is sybase.
The number of source columns and the mapping between the source and target coulmn is also fixed, but the source table name and column names are not fixed and needs be set while running job.

We are currently designing the jobs in open studio and exporting the job as job script(as POJO format on windows) and running the bat file for job execution.

Is it possible to change the table and column names after exporting the job.

Thanks
swami.

#2 2008-12-12 00:53:14

Volker Brehm
Member
Registered: 2007-04-03
Posts: 1139
Website

Re: changing the values of table and column names at job run time

Hi swami,

your solution would be to use context vars. It is possible to parameterize all your source information and set them at start time. For the column names of the destination table I'm not sure. How are you going to describe the mapping between your attributes of your metadata and the column names ?

Bye
Volker

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » changing the values of table and column names at job run time

Board footer

Powered by FluxBB