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



Joined: 07 Sep 2006
Posts: 1
Location: Chennai
Points: 15

Post Posted: Tue Oct 16, 2018 10:26 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi,

I have a requirement where in I need develop a DS PX Job which will generate the XML files based on different XSD, this XSD should be dynamic, which means that, the should not be any changes to the job when the XSD structure changes. is this possible? have anyone faced this kind of scenario? please advice.

_________________
Koti
ETL Architect
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3808

Points: 30639

Post Posted: Wed Oct 17, 2018 5:48 pm Reply with quote    Back to top    

Not really possible, because an xsd could mean structure change, different groupings, different hierarchy, multiple leafs, etc. It's not like a "schema" change in a relational environment. ....and the Stages take that into account and their metadata isnt dynamic on the links or in the assembly of the Hierarchical Stage.

"if" the xml is always fairly simple, you "might" be able to do something with the old xml stages, the xml Transformer in particular, which uses raw xslt at its core, but that will prove to be very difficult.

Describe how flexible it has to be, and how complex the xml is, and maybe there are some alternate solutions.

Ernie

_________________
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: 42896
Location: Denver, CO
Points: 221168

Post Posted: Thu Oct 18, 2018 5:09 am Reply with quote    Back to top    

I was just going to go with "no". Wink

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3808

Points: 30639

Post Posted: Thu Oct 18, 2018 7:28 am Reply with quote    Back to top    

yeah.. a lot of it depends though, on "how dynamic"? For example, if it can be one of (say) 8 xsds...then just have 8 instances of the xmlOutput Stage or the Hierarchical Stage (actually, you could ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Sat Oct 20, 2018 1:01 pm Reply with quote    Back to top    

Who gave you this requirement? Get them to justify it.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
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