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 have a sprite that has a Random Movement behavior. While the mouse is down, I want it to stop this behavior and initialize a Follow Sprite behavior instead. When the mouse is lifted, I want to stop the Follow Sprite behavior and reset/restart the R [More]
Hello Friends, I am in need of showing a xml report output through a button press trigger in Oracle Forms10G. I have designed the report in XML Publisher and the report looks fine.I found few scripts useful in running the Oracle Report from Oracle fo [More]
Hello All, I have created a project with the following structure: Project Defination (Construction of Sub station)       Main WBS                Level 1 WBS                          Level 2 WBS                                    Network for level 2 W [More]
i have a Jsp page.on left side of this page having menu bar. in this menu bar having links of some colleges. i want when i click on link of first college name, same page should be updaed with updated menu bar where i can show the information of the c [More]
Hi, I have an XML file containing information about my portfolio. I just need to show different information on my webpage when I click on an image. Here is my page: www.w00t.biz/beta.asp I would like to display information in the middle of the page w [More]
Hello Friends, I am facing some problem in changing the bachgroud color of the selected field in block, Basically i want to make visible the current field in a record,not the enire record but just the current item. thanks to all;Create WNII and POST- [More]
N95 boots always when I use GPS Maps (Kartat in Finnish) and select the from or to location using the Recent (Äskeinen in Finnish) feature. This happens also with the new 11.0.026 software. It lists the recent locations (I think so) and immediately t [More]
Hi I need to Know when it finishes Flash 8 movies ? Let me explain. I have powerpoint presentation move to flash( http://www.dreamingsoft.com/powerpointtoflash/quicktour.htm), and work fine. I need to put a mx:Button at the end of the movie presentat [More]
Dear Gurus, I installed ECC 6.0 SR3(ABAP+JAVA)  Development and Quality on the same server windows 2003 operating systems. in MMC it is showing only development system J2ee process table it is not showing the quality system J2ee process table. Can an [More]
What does this mean? I restarted computer as asked and that did not solve problem. Thanks.Have you tried looking at this document? http://helpx.adobe.com/creative-suite/kb/error-licensing-stopped-windows.htmlRead other 2 answers [More]