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.
Screenshot for Step

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.
Screenshot for Step
Screenshot for Step

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.
Screenshot for Step
Screenshot for Step


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 .
Screenshot for Step


5 . To test your interface, click Execute button . The following screen appears. Retain the defaults and click OK. On the next screen, click OK.
Screenshot for Step
Screenshot for Step



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.

Screenshot for Step


7 . Double-click Step 2 and click the Execution tab. View the number of rows inserted into the target datastore (15). Close the tab.
Screenshot for Step

No comments:

Post a Comment