I'm new to ODI & trying to create my first mapping between csv file and database table. Getting below error when selecting resource name in the data store.
The directory XXXX specified in your schema does not exist
I verified that the directory provided in physical schema is correct. The file is placed in local machine where ODI is also installed.
I placed my file in different paths, nothing works.
Physical schema should only read C:\xxx\yyy
Earlier I gave the full path including the file name in physical Schema (like C:\xxx\yyy\zzz.csv) which caused the error.
The datastore that you create in the relative model will be called zzz.csv