here is another detailed eg:

test--is my parent directory and it has many files such as

Code:

a1.txt
a2.txt
a3.txt

test1--subdirectory(under test)

Code:

b1.txt
b2.txt

test2--subdirectory(under test1 or test)

Code:

c1.txt
c3.txt

Now. my final file name should be like this:

Code:

<filename>_<tablename>_<clientname>.txt

i can read files from one directory, rename the files and put in desired folder but i cannot take files from multiple directories or sub directories in one go in informatica, either have to make different mappings for each directory(not a reliable option in long run).
So i want to take all files and put in one folder say temp:

Temp:

Code:

a1.txt
a2.txt
a3.txt
b1.txt
b2.txt
c1.txt
c3.txt

Now, i can process files in informatica all together and rename them according to the logic i mentioned above, after renaming files will be like:

Code:

a1_<tablename>_<clientname>.txt
a2_<tablename>_<clientname>.txt
a3_<tablename>_<clientname>.txt
b1_<tablename>_<clientname>.txt
b2_<tablename>_<clientname>.txt
c1_<tablename>_<clientname>.txt
c3_<tablename>_<clientname>.txt

after this, i want to put these files back to there original directory from temp directory, like:
test--is my parent directory and it has many files such as

Code:

a1_<tablename>_<clientname>.txt
a2_<tablename>_<clientname>.txt
a3_<tablename>_<clientname>.txt

test1--subdirectory(under test)

Code:

b1_<tablename>_<clientname>.txt
b2_<tablename>_<clientname>.txt

test2--subdirectory(under test1 or test)

Code:

c1_<tablename>_<clientname>.txt
c3_<tablename>_<clientname>.txt

**there will be 1000 files and 100s of directories, so i don't want to manually keep record of each file from which directory it belongs to, so here i would require 2 unix scripts, one script will put all files in temp directory and 2nd scipt should separate those files back to original directory.

Moderator's Comments:

Please use CODE tags as required by forum rules!