I have this informatica requirement where, i am getting some files say 1000 files, these files gets divided into multiple folders on unix server. i want to rename this file, let me give you an eg:
File name:input
abc1.txt
abc2.txt
abc3.txt
Now I want to change these file names by adding account_no,client_no,datestamp(all these values resides in one table). eg:
abc1_123_123_date.txt
abc2_456_321_date.txt
abc3_789_765_date.txt
This is just an eg: ..like this I ll be having say 10 listfiles and each listfile ll contain 100 files.Do i need to create 10 mappings for each listfile or is there any way that i can implement this in single mapping.
Please note:I cannot club all files in one folder and then change the file names and then again divide into original directories, as sometimes we get files in separated directories and we have to change there name and keep them in that particular folder only(for other business logic).
Kindly provide solution for this.
