How To Generate Dynamic Target File Based On Column Value

v_bhaskar · Post by **v_bhaskar** » Wed Sep 18, 2013 5:25 am

Hi Team,

Can any help on below Scenario

How To Generate Dynamic Target File In datastage Based On Column Value

Dept name, Dept ID, Location 
DWH           ,1       ,Mumbai 
Java          ,2       ,Bangalore 
Dot net       ,3       ,Delhi

i want to generate the file name as Mumbai.dat if the employee location is Mumbai.

Thanks

chulett · Post by **chulett** » Wed Sep 18, 2013 7:27 am

What 8.x release are you on? Pretty sure that functionality was added to the Sequential File stage at some point.

v_bhaskar · Post by **v_bhaskar** » Thu Sep 19, 2013 4:56 am

Hi Criag,

currently i m using 8.5 Datastage 8.5 Version

Thanks for your help in advance

chulett · Post by **chulett** » Thu Sep 19, 2013 7:09 am

Sorry, can't seem to find the details at the moment but did find this in my searches:

ray.wurlod wrote:Sequential File stage has the ability to generate the file name into an output column.

Hopefully someone can provide details on the 'how' of it.

ArndW · Post by **ArndW** » Thu Sep 19, 2013 9:28 am

Craig, that applies to reading from multiple files; in this case the OP wishes to write to a dynamic file name and I don't know if that works (I don't think it can work).

eostic · Post by **eostic** » Thu Sep 19, 2013 10:02 am

Sequential stage in 9.1 does this. Folder Stage in Server also does this, in any release.

chulett · Post by **chulett** » Thu Sep 19, 2013 10:03 am

Yah... you're right, that's just adding the column name to the input stream. I'd be curious what Andy or Ray have to add because I could swear it was added 'recently' to the product and one of them mentioned that fact. Or perhaps Vincent^H^H^H^H^H^HErnie. Could be wrong, however.

Old School would be to write the file out like normal and then take advantage of your O/S to split the file up after the fact.

chulett · Post by **chulett** » Thu Sep 19, 2013 10:07 am

eostic wrote:Sequential stage in 9.1 does this. Folder Stage in Server also does this, in any release.

Thanks... 9.1, eh? Was going to mention the Folder stage but it is somewhat of a PITA to use as a target and tends to confuse the crap out of people attempting to use it.