You can generate a separate output file each time the Integration Service starts a new transaction. You can dynamically name each target flat file.
To generate a separate output file for each transaction, add a FileName port to the flat file target definition. When you connect the FileName port in the mapping, the PowerCenter writes a separate target file at each commit. The Integration Service uses the FileName port value from the first row in each transaction to name the output file.