DSXchange

Thank you Andy!

Actually the large column will be only upto two stages, so I will give the buffer size to 9mb only to that particular stages in advanced tab and remove the parameter default transport size....Does that work?

I used 4 MB of block size and now due to a very big length column it is asking me to give 9MB which could cause the job to use more memory than needed since all the links would use a 9 MB transport block size. Any idea how to use that 9MB for only particular links to reduce the memory usage? Thank you

Thank you Sam, will follow the same!

The reason I am asking to do it in one job is the flow of the data is same all the way till target and you already said its not advisable. Is there any way where we can do it as it will be more complex to built an other job with the same flow..:( regarding your input So will the DB sequence in surro...

Hello, I have a Db2 table1 as target for which the key is DB Sequence generator. I also have an other table2 in the same job for which the key is the FK from the table1. Each time only one record will get inserted into the table1, once its inserted I need the seq value which has been generated and u...

Actually this was built through .net and we had issues when inserting records.
Now our plan is .net will trigger the ISD which will insert the records and send an error message to users.

The web service will be designed with close to 20 stages with medium transformations and inserted into tables. Each request we expect 10,000 records in the XML tag.

Hello, Have a question regarding the XML format of Web Service As of now our source is as below through a table Name(char) Entity(integer) Account(integer) Tran_CLOB(XML data) Prod_cd Prod_type Now we are planning to build a web service with the same fields but as WISD input and WISD output as below...

It worked now. I gave '****' for I_TRAN in the transformer before XML_output stage and after XML output I used an other transformer to replace '****' with '' and it worked as required. All records in separate tags.

Thank you very much!

This is the original XML seen in my table which should be for 5 transactions <?xml version="1.0" encoding="UTF-8"?> <TRANSACTIONS> <I_TRAN> <TRANSACTION_ID>123 </TRANSACTION_ID> <TRANSACTION_ID> 123 </TRANSACTION_ID> <TRANSACTION_ID> 123 </TRANSACTION_ID> <TRANSACTION_ID> 123</TR...

I think I tried a different way, just included a new column. Now I added an other column at the CHILD level giving it a sequence and I see the data in the below way which is not in correct format <Parent> <child> <newchild>1 <userID>123</userID> <Phone>6436431347</Phone> <Fax>5654345678</Fax> <Addr>...

I did the below changes, Added a new column which says ID and generated sequence number for it but still I see the same pattern. Only change is the ID is repeated now and rest all same just once.

thank you

I changed it to Aggregate button and all the data came into a Single XML file but all the tags came into one child tags like below <Parent> <child> <userID>123</userID> <userID>123</userID> <userID>123</userID> <userID>123</userID> <userID>123</userID> <Phone>6436431347</Phone> <Fax>5654345678</Fax>...

If it is about output tab---->Transformation settings--->outputmode---> I selected single row.

Please let me know if its some other setting....thank you!