DSXchange

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,

You might investigate the use of schema files.

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,