Skip to main content

File to Table Mapping

File to table Mapping using ODI

Step 1: Right click on file technology and select New data server

1

Step 2:Give proper name of Data server

1

Step 3: Define JDBC connection

1

Step 4: Register physical schema for data server

1

Step 5:Define schema and Work schema(source location)

1

Step 6: Create logical schema

1

Step 7: Go to Designer and right click on model and select New model

1

Step 8: Give proper name and select technology and logical schema

1

Step 9: create new data store for file

1

Step 10: Select data store type and select file that you want to map

1

Step 11: Define file format,heading, record separator and field separator

1

Step 12: Add new attribute

1

Step 13: click on reverse engineer

1

Step 14: create target data store

1. right click on target model and select new data store

1

Step 15: add attribute for target data store

1

Step 16:

1

Step 17: Drag source and target data store into mapping area.
click on target and select integration type

1

Step 18: Click on temporary data store and Select LKM file to SQL

1

Step 19: click on target and Select IKM

1

Step 20: click on run button to run Mapping

1

Step 21: View Operator to check status

1
You can see Mapping Successfully run

Step 22:Right click on target and select data

1

Step 23:Now you can see target table data

1