DataStage job or container to read multiple file formats

[shin0066]

Hi,

We have a requirement - where we receive source files in multiple formats like Delimited (csv, pipe), Fixed length, xml. looking for a common process where it reads different kind of source files and map to a specific schema file format - like format to target format based, target formats also can be different formats.

Is this possible in DataStage? if so what would be major components to build it.

for example - a trigger files provides source file location, source file format and target file location and target file format - based on that we need to read the source file and transform to target format and write to target location.

Thanks,

[ray.wurlod]

You might investigate the use of schema files.

[Terala]

HI Ray,

I looked at Schema File in PX developer guide, it doesn't provide a sample job.

Does any one have a sample jobs?

Thanks,