Processing Multiple Files simultaneously using BODS

[Former Member]

Synopsis: This will be a step by Step tutorial on reading multiple files simultaneously using a single file format.

Two tab delimited flat files of identical format are available. They need to be extracted using BODI and the data needs to be pushed to the same table. The files source_1.txt and source_2.txt as shown in the below diagram are taken for demo purpose.

In the file format, mention both the file names separated by comma.

Using this file format, data from both the file formats are extracted at one go.

Similar Options: A filename containing a wildcard character can also be used to read multiple files. In the above example, instead of using “source_1.txt, source_2.txt” as filename, you can also use “source_*.txt” to extract multiple files with similar naming convention.