Unable to Populate XML data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kondeti
Premium Member
Premium Member
Posts: 67
Joined: Sat Mar 04, 2006 11:38 am

Unable to Populate XML data

Post by kondeti »

Hi Everybody

I am reading an XML file from Sequential file stage. with help of only one sing key column with Varchar 255

After that i am processing that XML file with help of XMLInput Stage. In the XMLInput stage what i did is.

In Stage tab:

Transformation Settings:

A) I enable Repetition element required,Include namespace delcaration and i load the namespace from the respective metadata .xsd file.

In Input tab:

XML Source

I am reading the same source field as i am reading from sequential file as XML Source column.

and

Column Content as XML document

In Output tab:

Transformation Settings tab

I enable the Inherit stage properties

In columns tab:

I imported the total metadata from .xsd file.


For target I am using dataset


With the same configuration in serverjob i am successfully populating the data but in PX i am unable to populate the same.


Please help me on this.


Regards
kondeti
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Care to share your 'work around' ???
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply