DSXchange

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

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

Cheers
Aakash

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.

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?

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