Loading data from Csv file to db :

 Here my src file is in the below path..

I created table in db as per our data in csv file as shown below..

    

Create one data server for file technology.

 

JDBC connections automatically come..

 

Create one physical schema for that data server as shown below..

 

In logical Architecture, create one logical schema  and set context as shown below..

 

Again go to physical schema , set context as shown below…

 

Create one folder and in that folder ,create one model and set defition prop, as below..

 

Right click on model and create one datastore,(since it is csv file ,we are able to rev eng the data , through this datastore only)..

 

Give the resourcename as our file name as below..

 

Go to files and select file format and field separator as below..

Go to attributes and select reverse engineer…now we can able to see columns list as per our data in file.

 

 

Create new mapping and drag your source(data store here) and target table into mapping and set integration type as control append..

 

 

 

 

 

Go to physical layer,and set km’s as below…

 

 

And finally target table has data….