Implementing File Reader Transform in BODS

File Reader:

• Is used to read data from delimited text file (.csv).

Steps :-

• Right click on Project -> New -> Data flow.

• Provide Name and Description.
• Click on Finish.

• Go to Desktop -> Right click -> Click on new -> click on Microsoft Excel Worksheet.

• Provide name to the file.

• Right click on file and click Open.

• Enter column names.

• Enter data into the fields.

• Click on File.

• Click on Save As .

• Select CSV (MS-DOS).

• Click on save.

• Right click on Project -> New -> click on Flat File Format.

• Select automatically import file formats from existing files.

• Click on add files.

• Select the file and click on Open.

• Select the File and click on Finish.

• Here we can see the file.

• Drag and drop File Reader to the Data flow editor.

• Click on show list of values.

• Select the  file format.

• Click on OK.

• In work area now we can able to see File Reader.

• Drag and drop Template File.

• Join File Reader to the Template File.

• Click on Template Table -> Properties -> Click on root directory -> Click on show list of values.

• Select Desktop -> Click on OK.

• Click on File name -> Click on show list of values.

• Select the File and click on Open.

• Rename Template File.

• Looks like,

• Click save.

• Click on validate.

• Pop-up will appear "Validation results successful".
• Click on Close.

• Click on Execute.

• Select the Job Sever and click on Finish.

• Job execution is successful.

• Click on view trace log.

• Right click on Template Table -> Click on View data.

• Raw Data.