Use PowerCenter to create a maping to read data and generate dynamic flat files for each group of data.
Techniques Used:
1.FileOutPut port in the Target Source Definition
2. Concept of Grouping to create output data sent to the TCT
3. The Transaction Control Transformation(TCT)