DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Gius
Participant



Joined: 09 Mar 2015
Posts: 19

Points: 286

Post Posted: Tue Dec 05, 2017 11:01 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,
I need to do the following but don´t know which STAGE to use.

1- Read from a table (just one field XML_INPUT_FIELD LonNVarchar)
This table contains in this fields the XML.

This XML is for example as follow :

PERSON

PERSON ADDRESS List

PERSON ATRIBUTE List

Meaning for 1 person, I can have many address and many atribute

2- HERE I DON`T KNOW HOW TO DO THIS

I have to create 3 outputs :
- one row for PERSON
- 0..many rows for Address
- 0..many rows for Atribute
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Wed Dec 06, 2017 2:42 am Reply with quote    Back to top    

What have you tried? Do you have any XSD that describes the structure of your XML? If so, load that into the XML stage and the remainder becomes reasonably straightforward; you will have three outpu ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3724

Points: 29740

Post Posted: Wed Dec 06, 2017 6:25 am Reply with quote    Back to top    

You have several options. As Ray notes, the Hierarchical Stage is one possibility. This requires that you have an xsd. That xsd (schema file) will describe the "lists" that you have that generate t ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42280
Location: Denver, CO
Points: 217097

Post Posted: Wed Dec 06, 2017 7:33 am Reply with quote    Back to top    

I for one would also be curious how much experience you have working with XML - regardless of tool. And is the XML you have stashed in your database field a complete, well-formed XML file or is it just a snippet with the elements you've posted?

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours