Load the data form Oracle DB to File

Test is tested on OWB 10.2.0.4

1.Create the Location of file where it need to store. (on server where OWB Server is installed)
1.1 Go to Connection Explorer->File ->new
1.2 Create the location of file say FILE_LOC and path E:\owb_files


2.Create the File Module:-

2.1 Right click on the Files tab under your Project -> New
2.2 Select the location created in step 1.2
2.3 Finish

3.Create the mapping say( MAP_load_to_file)
3.1 Drag the target table to canvas.
3.2 Drag the flat file operator in canvas.
3.3 Then create unbound operator with no attribute.(Test1)
3.4 Select the INOUTGRP1 from Table(source) and drop it into INOUTGRP1 of file Test1
3.5 Right click Test1 Operator and "Create and bind"-> Create in -> select the file location created into step 2. then Ok
3.6 Right click Test1 Operator ->Synchronize ->Outbound ->OK
3.7 Close the map

4.Configure the Map:-
4.1 Right click the map ( Created Step 3. in MAP_load_to_file)
4.2 Click on Flat file Operator -> file name
4.3 On right side "Access Specification "
Fill the details :- Target Data File Location = created in Step1 (FILE_LOC)
Target Data file Name :-Give any name with extension like ( target_file.txt)
4.4 Ok

5.Open the map and validate .

6. Deploy and execute.