Generating Multiple files in 11.3 by using sequential file

vamsi_4a6 · Post by **vamsi_4a6** » Tue Oct 13, 2015 9:53 am

i have selected WriteMethod=Generate Multiple File for generating multiple files based on key.Job ran successfully but i do not know where the files will be created and also i do not find option to mention path for target files?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 13, 2015 1:55 pm

Possibly you're not looking in the right place, in much the same way that you're not posting this question in the correct forum.

chulett · Post by **chulett** » Tue Oct 13, 2015 2:04 pm

(sigh)

Moved.

qt_ky · Post by **qt_ky** » Wed Oct 14, 2015 5:30 am

The property where you mention the file name is no different from normal sequential file stage. You can also mention a path or use a parameter. Try it.

vamsi_4a6 · Post by **vamsi_4a6** » Wed Oct 14, 2015 8:35 am

Thanks for Input.I can generate multiple files by using below setting

Rootfilestring-path is mentioned here
key=emp
Usevalueinfilename=True

The outpur files are generated with following names

1.part00000
2.part00000
3.part00000

but what i need is

1.txt
2.txt
3.txt
Source file
empid,empname,sal
1,a,10
2,b,20
3,c,30

chulett · Post by **chulett** » Wed Oct 14, 2015 9:45 am

Seems like you should enable the Exclude Partition String property.

vamsi_4a6 · Post by **vamsi_4a6** » Wed Oct 14, 2015 10:03 am

Thanks and it is working.It is generating 3 files with name as 1,2,3.Is it possible to generate 1.txt,2.txt,3.txt without renaming the files

ray.wurlod · Post by **ray.wurlod** » Wed Oct 14, 2015 3:40 pm

Read the documentation again. What you are requesting is not how it works (for a number of reasons). You are up for a step of renaming the files.