DSXchange

Hi All, I am trying to read the XML file using Datastage PX. Design goes like this : External source ->XML input-> Sequential file. While trying to read the file, I noticed that some of data elements (tags) are repeating in the parent tag. We should have a seperate row for each repeating data elemen...

Hi friends, I have to generate an error file while reading the XML file source. XML source contains the information regarding customers in customer data set and each customer data set contains various data elements (tags).There are some required data elements (tags) that should be present in the XML...

Hey, I tried to read the XML file with sequential file stage but its giving some proble. I have set the XML input stage properly to read the XML file. Can you please help me to set the Sequential file stage for XML file reading. By setting i mean, can you please provide the properties/attributies th...

i will take care of this in future..... bi Standards Note U is a Burmese name (indeed, one of the posters here has that name), wat is a Buddhist temple, and wud isn't anything. Nor is gng. Please endeavour to use a professional standard of English on DSXchange. It makes things easier for those whose...

Hi Craig, U mean that we are going to set the seq file stage just to capture and pass the filename to XML input stage. If we configure the seq files stage to pass the filename only...then wat about the load of metadata...do we need load the metadata in Seq stage...if not then how we are gng to conne...

Welcome. :D So seriously, you couldn't find any of the XML stages in your palette? You have to have a job open in the Designer (other than a Sequence job) to see the appropriate icons for the job type, but unless yours has been customized they all should be there under the Real Time category: XML I...

Welcome. :D So seriously, you couldn't find any of the XML stages in your palette? You have to have a job open in the Designer (other than a Sequence job) to see the appropriate icons for the job type, but unless yours has been customized they all should be there under the Real Time category: XML I...

Hi, First thing first...Thank you very much for your help and support... Next thing ...you have mentioned that Sequential File stage is used to feed the XML input stage in PX. My question is How we are going to read the XML file in seq. stage...Do we need to set any properties in Seq stage to read X...

Hi Friends, I am new to DSxchange and Datastage both. I have a requirement to read XML file and post into oracle RDBMS tables. I am using DS 7.x Enterprise edition....the thing is that when i searched the DS pallete, I could not find any stage to read XML format file. Can you please help me to read ...