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
My creative cloud will not let me do anything.  It is blank white when I start it up.  I have restarted the computer.  I have uninstalled and reinstalled.  It will not even let me sign in.  I am also unable to use Muse.  It will not let me log in.  I [More]
Hi,   I export a schema "schema1" with name export1.sql i am trying to run this .sql at schema2 i am getting an error  ' input is too long () 2499 charecters" even if put set buffersize 100000 and set define off i am getting same error file [More]
My nephew just installed Snow Leopard on my IMAC 2008. I cannot get to printer to work. I have tried uninstalling the HP software and reinstalling. I have updated the software thru Apple updates. It still won't print or scan any documents.I would rec [More]
Hello! In same cases the result of multiplication in sql is rounded.For example, if i want to multiplay the numbers: SQL> select 38.69*0.335616438356164 from dual the result I get is: 12,985 but it should be: 12,98499999999364 Does anybody know where [More]
In my family we have 3IPhones 4S, one IPhone5, one IPad3, one IPadMini and two IPad 4. Is it possible to use the same energieadapter for all of those ?Yes but the iPhone chargers will struggle to charge the iPads ,they need more power than the iPhone [More]
Can some one tell me how to use the third party software such as Visual Basic, Powerbuilder to develop client application of Weblogic Server ? Is there any tool kit required to support such client application ? i.e: How to establish the connection in [More]
This is very aggravating.  My iTunes movies refuse to play in the iTunes player.  If I navigate to where the movie file is located, right click it and open it with quicktime, it will play flawlessly. If I try to play the video in iTunes it will just [More]
what is the URL for the keynote help link in the keynote app on the ipad. I have a firewall in place to keep student from accessesing unwanted/restricted information, where can I find the url/ip address to unblock this site. ThanksHi Ravi, As such th [More]
I have Lightroom 4.2 which isn't opening in Windows 7. A message comes up saying it's already open in another application; I can't see that it is. I've been using this successfully for 2 years now! I've tried shutting down and restarting; still not o [More]
Hi Experts,       I am new to XI         I am doing a file to HTTP test scenario.I want to know is there any test URL where i could try to post ?http://help.sap.com/saphelp_nw04/helpdata/en/82/f4993c03e0cd37e10000000a11405a/content.htm this sud throw [More]