I have two server

A: it's my oracle database server, installed odi studio, repository, alone agent A

B: it's a windows server, installed odi studio, alone agent B

I tried to load a csv file from B to A's database. but I can't correctly read the csv file on windows server B.

Here is the setup on windows B:

1. and Test connection is successful
2. Physical Schema
3. Logical Schema
4. Create a model
5. Create the datastore
6. I want the data from emp_tab.csv like this

What steps did I miss? please advise thank you.