Hi,
I have worked with server Edition and extracted data from XML inputs.
There was a stage called folder stage which takes two columns in the second i will the contents.in the input of the XML input stage i need to mention abt the contents either as a columns from folder stage or URL.
How can do the same in parallel jobs.From where i can pass the contents.
I have tried this logic
Row gen---->transformer(passing the URL) ----->XML input--->output.
But the URL which i am passing either as a string or through the job parameter both not working.Any inputs will be most appreciated.
Regards,
Bala
XML-Input
Moderators: chulett, rschirm, roy
Re: XML-Input
I really got confused, may be you can try to rephrase.bala_135 wrote:Hi,
... a stage called folder stage which takes two columns in the second i will the contents.in the input of the XML input stage i need to mention abt the contents either as a columns from folder stage or URL.
Are you asking for a way to pass the surce URL to the XML Input Stage ? For that you need to mention Column Content as URL and select the column containing that input. This you can do in the XML Input stage's Inout tab.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Hi Sud,
Thanks for the reply.Exactly what you have mentioned is right.I am asking a way to pass the source URL to the XML Input Stage.
Example:-I am the XML content in location say D:\customer.xml.
Do you mean to say if i pass this location as the URL in the input tab of the xml stage it will work.If thats is case how do i pass it in paralle jobs.
Regards,
Bala.
Thanks for the reply.Exactly what you have mentioned is right.I am asking a way to pass the source URL to the XML Input Stage.
Example:-I am the XML content in location say D:\customer.xml.
Do you mean to say if i pass this location as the URL in the input tab of the xml stage it will work.If thats is case how do i pass it in paralle jobs.
Regards,
Bala.
Unless the XML stages are different in PX, there's no way to supply anything like a filename or URL directly in the Input tab. You need to pass it in just like you've been doing in a specific field.
However, the Folder stage in Server jobs doesn't provide any magical functionality other than reading wildcarded filenames from a directory. I've used a Transformer to provide a single URL to the XML Input stage via job parameters and it works just fine in Server, so I'd imagine you should be able to do the exact same thing here.
You might want to elaborate on the 'not working' part of your first post where you said you tried that already.
However, the Folder stage in Server jobs doesn't provide any magical functionality other than reading wildcarded filenames from a directory. I've used a Transformer to provide a single URL to the XML Input stage via job parameters and it works just fine in Server, so I'd imagine you should be able to do the exact same thing here.
You might want to elaborate on the 'not working' part of your first post where you said you tried that already.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers