Creating a New ODI Interface to Perform RDBMS table to Flat File Transformation

To create a new ODI Interface to perform RDBMS table to flat file transformation, pefrom the following steps:

1 .	In ODI Designer, click the Projects tab. Expand your project Export-RT-FT, and then expand First Folder. Right-click Interfaces and select New Interface. In Optimization Context field, select Global.
2 .	On the screen that follows, enter the interface name as INT-EXP-RT_FT . For Staging Area select Oracle: ODI_STAGE. Click Mapping tab.
3 .	Click the Models tab to drag the source and target to the diagram. Drag the TRG_SALES_PERSON.txt datastore from the Flat_File1 model into the Target container. Drag the SRC_SALES_PERSON datastore from the Oracle_RDBMS2 model into the Source Datastore container. When Designer asks “Do you want to perform an Automatic Mapping?” click Yes.
4 .	Click the Flow tab. Click Target (FILE_GENERIC). The properties for the target appear below. For the IKM, select IKM SQL to File Append from the IKM drop-down list. Set the IKM options: TRUNCATE to true, GENERATE_HEADER to false as shown below. Click Save icon .
5 .	To test your interface, click Execute button . The following screen appears. Retain the defaults and click OK. On the next screen, click OK.
6 .	Open ODIOperator and verify that your interface was executed successfully. In Operator, click Session List tab, select All Executions, and the then click refresh button . View execution results for interface INT-EXP-RT-FT.
7 .	Double-click Step 2 and click the Execution tab. View the number of rows inserted into the target datastore (15). Close the tab.