DSXchange

Below is the posting from cmuller. Pipe any non repeating data to a hashed file stage, using serialno for the key. Then pipe repeating tags to the an xmloutput stage, and then to another hashed file stage to which you will write the repeating tags as xml chunks and use the serialno as key. It may lo...

cmuller, In your solution could you let me know how to handle a situation where I need the following output format. Please look at the last record. In summary I need to produce a closing tag (</Balance>) if there is no Balance value for the SubTotal. TotalPayment: <Subtotal>124</Subtotal><Balance>12...

Hi there, We are using DataStage 6.0.1 and I installed xml pack 2.0 and trying to create an xml output. I am facing a problem where there are multiple products for an Invoice and I do not know how to repeat the tags for the products. The outpur records looks like this. <Invoices> <Invoice> <Invoice_...

Hi there, We are using DataStage 6.0.1 and I installed xml pack 2.0 and trying to create an xml output. I am facing a problem where there are multiple products for an Invoice and I do not know how to repeat the tags for the products. The outpur records looks like this. <Invoices> <Invoice> <Invoice_...

Has any one used this option in calling an anonymous pl/sql block in an OCI stage.
Thanks.