BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

XML Job Ladoing more records than existing


 
Search this topic... | Search DI: Realtime and NRDM... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Realtime and NRDM  Previous TopicPrint TopicNext Topic
Author Message
murali353
Forum Member
Forum Member



Joined: 11 Aug 2011

Posts: 28



PostPosted: Fri Jun 29, 2018 4:42 am 
Post subject: XML Job Ladoing more records than existing

Hi Team,

I have given a xml file to load into a table. They have not provided me XSD.
below are the steps follwed
1. created xsd online for the given xml
2.i have used the xsd and xml to read data , i have created xml schema using xsd and imorted the xml file. over here when i click "view data" option i m getting xml parsing issue.
Then i have validated both using freeformatinng.com
3.used validated xsd and xml now i am bale to see data.

when i ran the job it is loading 60 lakhs records into table which not supposed to be.

question 1: what are all the possible reasons to get 60lahs records.
question 2: online will accept only 2 mb files, how to convert more sized xml file into xsd. (suggest best tool if any)

ETL Job:

xsd schema --> query (unnested the attributes)-->query1 (one to one mapping)--> temp table.


appreciate your responses.
Back to top
lindatovar
Forum Member
Forum Member



Joined: 10 Jul 2018

Posts: 1



PostPosted: Tue Jul 10, 2018 4:53 am 
Post subject: Re: XML Job Ladoing more records than existing

Can you give a specific example with pictures? fanfiction
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Realtime and NRDM  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0295 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0260)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo