My question is this: In your opinion can be managed through the XML input stage and XML output stage repetitive elements?
I'm using DataStage 7.5.2 parallel.
The design of my job is:
Sequential file ---> Transformer ---> XML Output Stage
I have a text file in this format: 1-Y7X1 | Boolean | N
and I would map it into an XML file.
The output XML file that I would have, should have the following structure:
Code: Select all
<TIM>
<outgoingAmount> 1 </ outgoingAmount>
<ingoingAmount> 1 </ ingoingAmount>
<Service>
<directionality> x </ Directionality>
<ServiceCh>
<name> ServiceType </ name>
<value> 1-Y7X2 </ value>
</ ServiceCh>
<ServiceCh>
<name> ServiceSubType </ name>
<value> 1-Y7X2 </ value>
</ ServiceCh>
<ServiceCh>
<name> bundledID </ name>
<value> 1-Y7X2 </ value>
</ ServiceCh>
<bidirectionalA> N </ bidirectionalA>
</ Service>
<additionalA> Boolean </ additionalA>
</ TIM>
<ServiceCh> repetitive so as to have the xml file that I have described above?
If someone has already managed to create an XML file with repetitive elements, you could send me an export of the job?
I hope I have been clear in describing my problem. Thank you in advance.