DSXchange

lookin at the funcationality of the folder stage which reads mulitple files. it only uses 2 fields one which has the file name and the other which puts all records pertaining to a particular file in one column .....

i dont get whats the point of doing this ? because if you merge records from different files, even with the same format , how can they be utilized in future use ?

thanks

It's not really for merging files. It serves three basic purposes:

1) Allows you to get filenames from a directory one by one.
2) Allows you to get filename and complete file content one by one.
3) Allows you to write multiple files to a directory.

Most of the time it is used for #2 feeding data to the XML Input stage which then parses / flattens the one long piece of content into individual data elements based on the XPath expressions in the stage.

hi thanks !! i was just going through an article..

it will help someone understand the same problem as mine ..

http://www-128.ibm.com/developerworks/d ... g/#step1.2

If your post has been resolved, please mark it as such. Thanks!