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. |
No comments:
Post a Comment