DSXchange

Hello Everybody,
I have sequential source file which consists of a country column, I need to create job which will create individual file for each country.

I know we can use the FileSet stage for this.
I want to know how to define partitions for each country.
How can we give our own target path and file name.
Please let me know.

Thanks in Advance
Arvind

I am not sure this will produce what you are looking for. You can use fileset to create one file per partition, but you may have multiple values per partition. For example, if I have 10 partitions but have 20 countries, then I'll have 2 countries per partition.

On the other hand, I think (someone please correct me if I am wrong), not specifying 'single file per partition' means the data is round-robined to each output file specified in the fileset descriptor.

Here's a different method you could try. Preload a dataset with your sequential source file, so you don't have to read it more than once. Then create a list of the unique country values (either a hard coded list you create once, or create a DS job to create the list dynamically). Then iterate through this list, and pass the value as a parameter to a job that filters out the specific values and exports to a file. If you setup the job to run with multiple instances, you could run several filters concurrently.

HTH,

Brad.

Arvind,

For your problem easy solution is to use filter stage directly and
1: If you want to run multiple instances of the job then parameterise the job i.e. in filter stage pass column in where clause and parameterise the where clause with country name,and specify the output link,and in the out put file also parameterised the output file name so that u can have country wise file name,

2: If you want to run the job once and want the output at one go then u can use same filter stage with multiple output file options ,in where clause of the filter give country name with country column and specify different output links with country names

Isn't this requirement exactly fulfilled by a Switch stage?