Sitemap

Amicuk Programming Answers

Loading data from a flatfile versus xml

-0001-11-30   Views:0

Advertisement

As of now we are loading data from the AS400 by using flatfiles. For the sake of uniformity and flexibility we want to start using xml instead of flatfiles. But for what I have seen the loading of xml seems to be a lot slower then flatfiles. I think

As of now we are loading data from the AS400 by using flatfiles.
For the sake of uniformity and flexibility we want to start using xml instead of flatfiles.
But for what I have seen the loading of xml seems to be a lot slower then flatfiles.
I think I have to chose between two options
Loading infto xlmldb - XMLTYPE
or
make use of DBMS_XMLSTORE.
I think it would be best to use the pl/sql package because we will not need extra storage for the xml table and then the fastest way should be dbms_xmlstore since it is written in c.
If someone can come up with another, faster way, fine with me.
If I want to use the package I have the following problem.
I know how to tell which columns to load but my source xmlfile needs to be stored in at least 2 tables.
It was possible with wb_xml_load but I think dbms_xmlstore is the faster solution.
Can anybody tell me how to proceed?
A little performance degradation is OK but we still need to load lots of data, so the faster the better.
regards.

The replay answer
Advertisement
Hi Priya
There is a post on leveraging XDB with some interesting details;
http://blogs.oracle.com/warehousebuilder/2007/09/leveraging_xdb.html
Cheers
David

Go to See the other 2 answers

Loading data from a flatfile versus xml

Category:DefaultRelease time:-0001-11-30Views:130

As of now we are loading data from the AS400 by using flatfiles. For the sake of uniformity and flexibility we want to start using xml instead of flatfiles. But for what I have seen the loading of xml seems to be a lot slower then flatfiles. I think[More]

How to load data from oracle table to XML using ODI ?

Category:DefaultRelease time:2015-10-11Views:130

Hello Team I am trying to load data from an oracle table to an xml file. I have configured the physical and the logical schemas for the same. I have used SQL to SQL as LKM and SQL to SQL Append as IKM with Sunopsis Memory Engine as staging area. Afte[More]

Best Practise for loading data into BW CSV vs XML ?

Category:DefaultRelease time:-0001-11-30Views:130

Hi Everyone, I would like to get some of your thoughts on what file format would be best or most efficient to push data into BW. CSV or XML ? Also what are the advantages / Disadvantages? Appreciate your thoughts.XML is used only for small data field[More]

Need to Load data in XML file into multiple Oracle tables

Category:DefaultRelease time:-0001-11-30Views:130

Experts I want to load data that is stored at XML file into multiple Oracle table using plsql. I am novice in this area.Kindly explain in depth or step by step so that i can achive this. Thanks in advnace.Hi, extract your xml and then you can use ins[More]

Error when loading data from xml file

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm trying to load data into a table from XML file using ApEx DATA UNLOAD/LOAD interfaces . ApEx version is 3.0.1 . I'm getting this error: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00222: error received from S[More]

How to write a procedure to load the data into a table using xml file as input to the procedure?

Category:DefaultRelease time:2015-10-11Views:130

Hi, Iam new to the xml, can u please anyone help me how to write procedure to load the data into a table using xml as input parameter to a procedure and xml file is as shown below which is input to me. <?xml version="1.0"?> <DiseaseCode[More]

Loading data from flatfile to relational table,i am getting SQLLDR error

Category:DefaultRelease time:2015-10-11Views:130

Hi, While loading data from flatfile to relational table,i am getting SQLLDR error and i am unable to proceed further. Source is a flatfile and target is a Oracle database,i used "LKM file to oracle(SQLLDR)" and "IKM sql control append"[More]

Error while loading data to ods object from flatfile

Category:DefaultRelease time:2015-10-11Views:130

hello all Iam loading data from flatfile to ods object and the processing type is PSA and then to data target(package by package),data arrived in PSA(its green) but in monitor the request is in red and in details tab of <b>subsequent processing</[More]

Issue to load data from database to XML file. error: ODI-40768

Category:DefaultRelease time:2015-10-11Views:130

Hi, While I am trying to load data from database to XML following error is appearing. ODI-1228: Task TEST_XML_DATA (Integration) fails on the target XML connection MyLOCALXSD. Caused By: java.sql.SQLException: ODI-40768: Could not save the file <defa[More]

Load data from xml file in oracle data base

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I'd like to know if is posible to load data from a file xml into a table of oracle data base through SQL*LOADER, loaded only in a normal column no with type XMLType , for example I have a xml file <person name="kate" surname="far[More]

How to create XML data source/ and load data from a web service to BI

Category:DefaultRelease time:2015-10-11Views:130

All, I m trying to find a 'how to' document (or any document) that shows how to create an XML data source to load data directly from a web service or from an XML file. I appreciate any help.Hi Mike, Two more for you:---- /thread/111488 [original link[More]

Hot
I a Search Application,I need to find the documents, where a StringAttribute (Author) contains any of the values in a specified array. For this purpose, I use an AnyOf-query (combined with some other queries). Alas I keep getting the following error- [More]
I have just switched to Windows 7 and Elements 9 - so far things are working quite well, but I am having a problem with "Watch folder"  It is watching my odf folder "My Pictures" but all my new photos are going into Libraries/Pictures [More]
How can i get Windows 7 installed on my mac? Is it pre installed ? can i get it pre installed when i buy a new one ? Regards, Robin PauloseRobin, Welcome to Apple Discussions. MS Windows must be purchased separately, you can buy it anywhere Windows i [More]
Adobe Photoshop Elements 9.0.3 Update   There was an error downloading this update. Please quit and try again later.   Photoshop Camera Raw 6.5 Update   There was an error downloading this update. Please quit and try again later.Hi, Which operating s [More]
okay i wanna upgrade my hp with an actual graphics card, so i can play games without it lagging. i mainly play rts games, like command and conquer generals, etc and about to get company of heros. now i need to know what kind of card i can put in this [More]
i have an 875p neo. i am one setting away from loving this mainboard(finally). i have a 2.8ghz running at 3.0 (with a 1:1 FSB/RAM). i can run stable in TURBO MODE, with "timings by SPD". i am using 1.7 bios (1.8 gives me lower performance). i tr [More]
Hi all, I have an enquiry here. In VKM4, we can see that there is a 'Foward' icon where we will be able to foward the respective sales order to an authorize person for approval. After I Foward and Save it, system only prompts me saying the SO has bee [More]
We are using our exchange 2010 server has our messaging solution. we are also use our SharePoint 2010  for our portal. we are enabled multiple domain( abc.com, xyz.com) in our exchange and able to send and receive mails properly. for some  reasons we [More]
os:redhat linux AS oracle:10.2.0.3 hai.. i am new to rac. if production environment using orace rac with all failover components like two hbas,two fc swithces,four network cards(two for private interconnect, and remaining two for public) and four swi [More]
Hello, When I open and close a pdf file with acrobat, then it's impossible for me to edit and save with another program. "File already opened". I think Acrobat keep it open or something like that, even if I close it. Is there an option to clear [More]