output file name with the data from input file for each rec

chaithanya · Post by **chaithanya** » Sat May 25, 2013 1:09 am

To Create a job to generate the output file name with the data from input file for each record.

Ex: Input File

dob_year,dob_month,dob_date,name
1985,10,05,Kannan
1986,11,05,Kumar

Output file name should be:
Employee_Kannan_1985-10-05.txt

ray.wurlod · Post by **ray.wurlod** » Sat May 25, 2013 1:58 am

Sequential File stage has the ability to generate the file name into an output column.

chulett · Post by **chulett** » Sat May 25, 2013 7:16 am

Again with the posting of what seems to be a work assignment without questions or any evidence you've even tried to solve it. More of this 'testing' going on?

chaithanya wrote:I am a datastage trainee in my company. My lead gave this scenario to test my design capability.

chaithanya · Post by **chaithanya** » Sat May 25, 2013 10:41 pm

I tried to write routine to load data of each record to seperate file, with the name of the respective record. But found it very difficult. Kindly appreciate if anyone could provide any tutorial link for routines. Thanks for the reply ray and chullet.

ray.wurlod · Post by **ray.wurlod** » Sun May 26, 2013 12:18 am

You can get a training class on Programming with DataStage BASIC, which has a comprehensive treatment of working with BASIC routines, from DSXchange