Page 1 of 1
Generating Multiple files in 11.3 by using sequential file
Posted: Tue Oct 13, 2015 9:53 am
by vamsi_4a6
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?
Posted: Tue Oct 13, 2015 1:55 pm
by ray.wurlod
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.
Posted: Tue Oct 13, 2015 2:04 pm
by chulett
(sigh)
Moved.
Posted: Wed Oct 14, 2015 5:30 am
by qt_ky
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.
Posted: Wed Oct 14, 2015 8:35 am
by vamsi_4a6
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
Posted: Wed Oct 14, 2015 9:45 am
by chulett
Seems like you should enable the Exclude Partition String property.
Posted: Wed Oct 14, 2015 10:03 am
by vamsi_4a6
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
Posted: Wed Oct 14, 2015 3:40 pm
by ray.wurlod
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.