Loading Flat File to Table in ODI 11g

Loading Flat File to Table in ODI 11g

Step1: Creating Flat File

1. Navigate to folder C:\OBIEE_HOME\Oracle_ODI1\oracledi\RRITEC
2. Create a text file as shown → name it as emp → save → close
3. 

Step 2: Creating File data server and physical schema

1. Open ODI 11g Studio
2. Go to topology tab
3. Right click on file technology
4. Click on new data server → provide below information
5. 
6. Click on JDBC → provide below information
7. 
8. Click on save
9. Right Click on RRITEC_FLATFILES data server → click on new physical schema → provide as shown
10. 
11. Click on save → click on ok

Step 3: Creating Logical schema and mapping to context

1. Expand logical architecture → right click on file technology → click on new logical schema → give name and map to context  → save
2. 

Step 4: Creating Model

1. Goto designer navigator → under the models section → right click on RRITEC model Folder  → Click on new Model → Provide as shown
2. 
3. save → Close
4. Right clcik on above model → clik on new data store → in definition tab  
5. 
6. Click on files tab
7. 
8. Click on columns tab
9. 
10. save → close

1. Connect to your target schema( ex : B10711GTDBU)
2. Execute below script
3. 
4. Reverse engineer this into target model
5. 

Step 6: Creating interface

1. Expand projects → expand RRITEC folder → Right click on interface → new interface
2. name it as m_flatfile_to_table
3. Click on mapping tab
4. Drag and drop source and target
5. Make sure automatic source to mapping created and select the workspace as staging area
6. 
7. Select flow tab → select source → select LKM as LKM FILE TO SQL
8. 
9. Select target → select IKM as IKM SQL CONTROL APPEND
10. 
11. select the option FLOW_CONTROL = FALSE
12. save → run
13. Observe output
14. 

Step 6: Add filter to above interface

1. Duplicate above interface and rename as m_flatfile_to_table_filter
2. click on mapping tab → from source drag and drop Deptno column in to empty work area
3. select the filter object → provide below condition
4. 
5. Click on flow tab
6. select target → select truncate option as true
7. 
8. save → run → observe output
9.