DSXchange

Hi, When I tried to migrate information server from Unix to Window2003 server and started installation of IS server on window and during installation, I pointed to repository to oracle which is installed on Unix server. And it impacted on my existing project on Unix server and I got following error ...

Thanks for prompt reply.
1st agg, using first () function
2st agg and 3rd agg, using count(*).

Columns were grouped by ODBC stage are different from Agg stage and so I will try to use same columns used in agg stage to group by in ODBC stage.

Hi everyone, I searched through all the posted of mutex issues in this forum. But it doesn't help to fix my jobs. I have a job using IPC stage and getting this 'ds_ipcput() - timeout waiting for mutex'. I used default buffer size (128) and time out (10) previously and increased buffer size like 258 ...

Hi, I also faced the same problem. My DS job which called stored procedure in sql server is hanging for 1 day. Inside stored procedure, creating 2 temp tables and updating to some coumns in same table.Total no of records are 22 millions in table and it may be the problem.Is it possible to do it in u...

The job has 4 sort keys. Finally, job has finished, but it took 10 hrs to complete.Is there anything that I can do for better performance?

Thanks a lot.

Thanks Arnd.
Jobs are using IO time and not CPU. It is currently taking around 5hrs to sort 500K records, but still not sort out single record.

Hi, I have a problem with using sort stage in ETL job. The source data is from seq file and do the sorting in stage and transform and load to sql server. But the records are not moving out from sort stage after it read to input stage. But the status shows 'RUNNING'.Total no of records ar 500,000. Ma...

Hi, I'm facing some problem of spliting two colums (header, detail) of files into two rows. Following is my sample records: Input File is like below: Header , Details A, B I would like to have the Output like: Header A Details B Is it possible to get the output like above? Thanks a lot, san san

Thanks you very much,cmueller.
I'm able to write the repeating tags to the xmloutput,but is there any other ways instead of using hash files? As I have over 10 millions records which saved in the hash files,and then it's comsuming a lot of spaces in DatastagServer.

Hi, I want to produce an XML file,but I faced one problem.I have tags which occurs 4 times (TotalPayments). I don't how to write it in Xpath to occur 4 times in the output XML file.I tried to use (SaleRecord//TotalPayment/Subtotal) but show me the error "the derivation rule is invalid". Cu...

Yes, I think I have more than 15k records to the rejected file as I have 10 million total records to convert to the database.

Thanks a lot,
san san

Thank you so much for your help. I tried to use the follwing method: If Mod(@INROWNUM,15000)=0 Then 1 Else varSequence + 1 But it works for generating no of incoming rows, not for generating no of outgoing rows. What i actually want is that the sequence number of output records that go to the Databa...

Hi all, I've a problem to reset the generated sequence number automatically after 15k records are executed. I used @OUTROWNUM system variable to write sequence no for first 15k records, but I want to reset to 1 after 15k records. Total records of this job running are 4 millions. So how can i do to r...

Thanks a lot,ariear.I'm currently using XML Meta Data Plug-in and version is 6.0.15. I'm not sure which version of XML pack I'm using. How can i check it? As I'm a new user of datastage. Two more things I'd like to know that are: 1) I can create the XML doc from squential file stage by exporting as ...

Hi Shiva,

I'm also facing the same problem now like" W3CXML Schema'(XSDL)not supported".How can you import the schema?


Thanks a lot