Hi,
I am facing a strange problem in handling a complex CSV file.
The content of the file is as follows. It is getting executed through an XSD and the target is a table.
First time when the interface is executed ( for e.g session id - 19001) it is getting completed successfully.
Now when making changes in the CSV file suppose adding ( for e.g.-
DEPT,D05,Books,ABC Store
CUST,C01,Sayantan,sayantan@retail.com
CUST,C02,Shubham,shubham@retail.com)
or deleting ( for e.g.-
CUST,C02,Sarbajit,sarbajit@retail.com)
and running the interface I am not getting the added D05 in the target table nor my C02 data is getting removed i.e.- the updated data in CSV file is not getting fetched and I am getting the same records as i got when i ran interface of session id 19001.
I am not getting why it is happening??
The CSV file used in session id -19001 is:
DEPT,D01,Retail,World Mart
CUST,C01,Anindya,anindya@retail.com
CUST,C02,Rashni,Rashni@retail.com
DEPT,D02,Food,Food Bazar
CUST,C01,Abhijit,abhijit@retail.com
CUST,C02,Anirban,anirban@retail.com
CUST,C03,Sharmistha,sarmistha@retail.com
DEPT,D03,Water,SW
CUST,C01,Nirmalya,nirmalya@retail.com
DEPT,D04,Clothes,City style
CUST,C02,Sarbajit,sarbajit@retail.com
CUST,C03,Abhishek,abhishek@retail.com