Reverse-engineering a Fixed File using the Wizard

Oracle Data Integrator provides a wizard to graphically define the columns of a fixed file.

To reverse-engineer a fixed file using the Wizard:

1. Create or open a file datastore that has a fixed format.

2. Go to the column tab

3. Click the Reverse button. A window as shown below. This window displays the first records of your file.
   
   

4. Click on the ruler (above the file contents) to create markers delimiting the columns. You can right-click in the ruler to delete a marker.

5. Columns are created with pre-generated names (C1, C2, and so on). You can edit the column name by clicking in the column header line (below the ruler).

6. In the properties panel (on the right), you can edit all the parameters of the selected column. You should set at least the Column Name,  Datatype and Length for each column.

7. Click OK when the columns definition is complete.