This content has been marked as final. Show 5 replies
LKM File to SQL
csv file can be connected using File technology,
you can refer
Oracle® Fusion Middleware
Connectivity and Knowledge Modules Guide for Oracle Data
11g Release 1 (11.1.1)
To transform a csv file to an xml file is it mandatory to use a relational database as a staging area?
Do you have some tutoria or step by step guide to reference?
No you can use the Sunopsis Memory Engine as a staging area , its a Hypersonic SQL Database in memory.
Try here for a good introduction :
good starting point.
Do you know if it's possible to join two csv source files in the the Sunopsis Memory Engine as a target?
Yes it is, you wiill LKM each file into the memory engine, do the join on the 'staging' area as such and your in business.
Keep an eye on your Agent memory usage if the files are large, try and filter out as much as possible on the source , if you can.