DSXchange

eostic,

Than you for your inputs. My userid got locked so couldn't reply to your message. I created a new userid for premium membership.

We have asked the consumers to flatten the xml structure and gave the same WSDL and it is working fine.

Thanks
Raghavendra

We have a created a Name Search Job in QualityStage and exposed it as a web service. Our idea here is that this should be consumed by multiple applications. We have defined a CMM standard xml response and request for this web service. We have imported these xmls and created the Job. The Job is worki...

We have a requirement to search a database for a customer based on Name and Address fields. The search happens in real time from a web service. We have customer database with 10 million rows (Name and Address are not standardized) and it can be updated in real time with new customers. When we invoke...

You can export the whole project as a single dsx file and then run some scripts to parse the file and create one dsx file per job.

For more information refer the following link

viewtopic.php?t=113429

I believe we cannot compile a job in through the command prompt.

First sort the data then using a copystage send the rows to two links. On the first link add a new column (KEY) with generated numbers from 1. On the second link add another column(KEY) with generated numbers from 0. Join both the links using generated column (KEY) as a key column. The First Link wi...

In this example I see you have a set of 5 records. In your data, is this set of records fixed.

I have implemented the same kind of logic in server using db2.

I have fired a query using Count(Primary key) first and checked if it is 0 or more. If it is 0, write 0 in the sequential file directly else do the other processing as required.

In After Job sub-routine write a script to check if there is a reject record.If you find reject record then move the file to the required location.

I belive in latest versions (7.5V onwards) transformer is not a performance overhead.

Is your file name ends with ".v"

Can you please let me know what is CART input file & Control file?
Is CART some different file type?

I will prefer to set the partition to same in the sort stage for this scenario.

Do you what is the maximum number of rows that has to be converted into columns?

How are you going to maintain the history in the database? Which type of SCD you are using? IS it type 1 or 2 or 3. If you want to generate the surrogate key how would you like to generate. Do you want to generate it within the DataStage or do you want to generate it using a sequence in database? Pl...