DSXchange

Hi,
I have a requirement where to load data coming from multiple sequential files to different target tables. The table that need to be loaded for a particular file will be available in a lookup table where we'll lookup on file name and get the table name that needs to be loaded. My query is how to load the respective target table after fetching the name from the lookup table.

Reagrds,
Balu

Do the lookup in a sequence and pass the table name to the job as a parameter.

Please explain me how to do this.

Thanks in Advance.

Do all of these target tables have identical metadata?

The sequence has two jobs, one to read the table name based on the file name (presumably a sequence parameter) and load that into its user status area. The second job does the load, with the table name passed as a parameter value whose value is obtained from the $UserStatus activity variable of the first job.

Because it processes at most one row, the first job should be a server job.