Reusing same job to load multiple tables of different DDL.

gsherry1 · Post by **gsherry1** » Tue Jul 03, 2007 9:01 am

Hello Forum,

Is it possible to use the same load job to load multiple load files with different columns and delimiters to different target tables.

My idea was to use parameterized schema files to handle/parse the load file, and parameters for the rest of the connectivity information. I've done such things with normal ETL processing before, but was wondering if there is something special about the load stages that might make using schema files not work.

Thanks,

Greg

aakashahuja · Post by **aakashahuja** » Tue Jul 03, 2007 9:54 am

Not sure if schema files work with database stages..... !!!!! you might want to check that out...

Cheers
Aakash

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 9:59 am

It's possible; it's not best practice.

Parameterized schema files for the source files, and rely on RCP and parameterized table names for the loads.

No guarantees - you may need to tweak some other aspects.

Maveric · Post by **Maveric** » Wed Jul 04, 2007 12:39 am

gsherry1 wrote :"multiple load files with different columns and delimiters to different target tables".

Different columns can be handled by using RCP. Different tables using parameters. But different delimiters? can that be handled? i have a similar requirement and i am using a multi instance job. But the source files are all DataSets. So not sure if different delimiters can be handled?

Maveric · Post by **Maveric** » Wed Jul 04, 2007 12:41 am

since u said different "delimiters" i assumed it to be sequential file. Is that correct?