For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Can pls anyone help me with the above problem.
Thanks.
I think you need to synchronize your file.
The first time you run the interface, ODI creates the tables based on your XSD and populates them with the data. If you change the data in the XML file, then you need to synchronize the file for the changes to be picked up. See B.4.9 SYNCHRONIZE in the XML driver documentation:
Oracle Data Integrator Driver for XML Reference
Hi,
Thanks for the reply.
I have got the solution.
Synchronization is not needed over here.
If we configure the Data Server in the following manner, any update or delete in CSV file will reflect in the target.
jdbc:snps:complexfile?f=C:\cstdb\cstdb.csv&d=C:\cstdb\cstdb.xsd&re=Root&ro=true&dod=yes
Here dod means drop on disc. It automatically drops the schema when we close the JDBC connection.
Glad you got sorted. Yep, DOD will do the trick too. I personally prefer to maintain the tables post-load and use synchronize, especially if it's a reusable process and I expect the files I'm loading to be in a consistent format.
But as always, whatever works best for your process.
Here's what you can do to handle CSV files using HSQL.
Say the CSV file contains order data. Each order record contains data about a particular order like order number, product code, quantity, ordered by, date etc. Now lets take a hypothetical requirement which says, the user needs to know how many orders were ordered per product.
So where does this leave us? Have we run out of options? I am sure we would have tried & used the above two options . But I wanted a different approach. Following questions were lingering in my mind:
Continue Reading Here: Handling CSV Files