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
Hi everyone. I have a little problem with brushes on cs5 photoshop... The problem is that if brush is big I can't see half of the brush, but if it's small like 50px I can see it all. Maybe someone knows how to fix this problem so I could see the brus [More]
This is probably a fairly simple thing to do, but for some reason I can't get my head around it... Is there a way to connect my iPhone to my mac without iPhoto starting up automatically? I do want iTunes to start, as this is set up to sync calendars, [More]
I upgraded to OSi 10.9.3 as my comptuter told me to do-I am very obedient that way. Now the bars on the side of mail and safari that allow one to move the screen up and down-are not there-except for sometimes.. I have looked everwhere in Preferences [More]
Visiting a friend where I have installed an Airport Express way back and where I usually connect my MacBook generations, I found that my new MBA would not connect. First, "cannot find any preferred network" When selecting the adequate network, w [More]
i can't open my iTunes store on my laptop, which isn't apple and I can't update my iPhone 4 either. can some1 help please?  I've installed all the updates and tried Firefox tooMany thanks. Just in case, try gn_id's suggestion from the following post: [More]
Hi All,     Can we enter any number of values in select-options on the selection screen. What is the limit on the number of values that can be given for select options. For example if the limit for a select-options field is 100000 and if i want to gi [More]
Is there any way to do negative character tracking? Other than to individually separate each character. It is possible in many other apps such as Muse, Illustrator, Indesign, Photoshop. Why is not a feature in Adobe Edge Animate?Use css letter-spacin [More]
Hello, I recently changed my iCloud password, after updateing to Mountain Lion (10.8.2). I wanted to access the "Back to my Mac" feature and I was asked my password. I set up a new one on the web as I had troubles remebering it (or maybe it's th [More]
Hi I am getting an error while creating MRP run.This is the error: MRP parameters for plant 'ZAK1' have not been maintained. Can anyone tell me how to remove this error. Points will be awarded. Thanks and Regards. SubhashI went to Img SPRO -> MM -> [More]
Hi all, Can anyone give any advice as to rebuilding an ACTIVATED RAC physical standby using RMAN? We have been able to revert the db with flashback but I need to know the rebuild method. Is there any extra steps with the OCR? I am guessing the steps [More]