Using flat file (delimited file) as a source in Data Services
Here is an example of how to use a delimited flat file as a source in BODS.
Now we need to create a File Format for which we will be using our input file as a source.
9. Now click on Save and close.
10. The file format will be created and this can be now used as an input for your job.
Using Multiple flat files (delimited) as source with single file format
We can also choose multiple files instead of single file by separating the file names with commas or placing wild card character at the end of the file name.
For example I have taken 2 input files Test1.txt and Test2.txt
Below are the inputs of these 2 files.
In the File Format Editor, the place where the File name is specified, place Test*.txt. This takes the input from 2 files (Test1.txt and Test2.txt). We can also provide the file names separated by commas.
The output of the job is combined with both input file Test1.txt and Test2.txt as shown below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |