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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[DI] Core Tutorial Populating from nested XML File


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
schnadi_uk
Senior Member
Senior Member



Joined: 13 Dec 2004

Posts: 33
Location: Yorkshire, UK


flag
PostPosted: Mon Jan 17, 2005 6:06 am 
Post subject: [DI] Core Tutorial Populating from nested XML File

Hi...

I am fairly new to BO Data Integrator and am working my way through the Core Tutorial. So far so good until i come to Chapter 6: Populating the Material Dimension from a Nested XML File.

When validating my objects i get the following error:
[5646] [Target Table:mtrl_dim(target_ds.dbo)] Cannot find the matching name for <source> column <MTRL_MASTER>

I have played about with this to try and eradicate the problem but no luck. Has anyone any ideas or done the tutorial themselves??

Thanks in advance,
Paul
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10593
Location: Germany


flag
PostPosted: Mon Jan 17, 2005 7:16 pm 
Post subject: Re: DI Core Tutorial Populating from nested XML File

Check the name of the field in the target table. It is your job to make sure (in the query upfront) that the name is exactly the same. So you will have to rename that column in the query by double-clicking the MTRL_MASTER field and change its name.

Sorry, don't have the tutorial pdf at hand to check if there is an error in the scripts

Werner

_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io
Back to top
schnadi_uk
Senior Member
Senior Member



Joined: 13 Dec 2004

Posts: 33
Location: Yorkshire, UK


flag
PostPosted: Tue Jan 18, 2005 6:19 am 
Post subject: Re: DI Core Tutorial Populating from nested XML File

I have now worked around this and managed to get the damn thing working.

There was a slight error in the manual as it doesn't tell you how to deal with nested output and refers to qryUnnest as qryFlatten. Just ignore the qryFlatten.

To Unnest the output, simply make the necessary scheme 'current' and by right clicking the object, you have the option to 'unnest'.

Thanks,
Paul icon_lol.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  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.0290 seconds using 17 queries. (SQL 0.0023 Parse 0.0014 Other 0.0253)
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