Writing data to a new Microsoft Excel file

You can use the Unstructured Data stage in jobs that write data to a new Microsoft Excel file by specifying the full path name. You can also create multiple Microsoft Excel files by specifying the location from where the files are created and a prefix for the file names.

Each input link of the Unstructured Data stage is associated with a separate Microsoft Excel sheet. The Microsoft Excel sheets are named associated with the input links that are as Sheet1, Sheet2, Sheet3, and so on. Each InfoSphere DataStage column of the input link is mapped to a Microsoft Excel column.