DSXchange

I put a search for vertical pivot and got my solution.

Thanks for the help from all of you.

I put a search for vertical pivot and got my solution.

Thanks for the help from all of you.

I have a flat file like this. 1,Nick 2,Deve 1,Tom 3,Ron 2,Neil I want to generate another flat file from this in this format. 1,NickTom 2,DeveNeil 3,Ron Can anyone tell me the best approach to do that? I tried a group by using aggragator but it is not giving me in the format i want. What should be d...

Hi I am getting the following error. Can anyone tell me what does it mean? RateHashTRansfrom..InterProcess_118.dsupd_MergedData: ds_ipcput() - Error in mutex_unlock() - Not owner The flow of job is like this. Sequential file -> TRansformer - > Link collector -> interprocess - > transformer -> Flat f...

Alrt... Here you go... my XML look like this ------------------------ <ROOT> <FILEINFO> <NAME>MODELFILE</NAME> <TYPE>XMLPLAIN</TYPE> <REGION>EUROPE</REGION> </FILEINFO> <ADDS> <ADD> <PLACE> UK</PLACE> </ADD> </ADDS> </ROOT> my XSLT look like this ---------------------------- <?xml version="1.0&...

sry :D

tnx

Do we need to set anything special in the Datastage / server to see the perfomance statistics? I mean, if we turn on/off something (unix /datastage level enviorment variable / Administrator setting etc) , so that we will not be able to see the input and output link count. any help in this regard wil...

Thanks a Lot. Let me add something to it. What should be the best way to abort a job, incase the output link bring Zero record to me? What is happening is incase the output link give me Zero records, everything go for a toss... No check is working with that link. I would liek to get an easy way to a...

I have a requirement. I am using an XML input stage and using xslt to get some specific data from the xml and push to a flat file. Incase my xml don't have any tag which i want then the xml output link will give '0' recods and the remaining part of the job will pass through. To handle this situvatio...

I got a fixed length flat file. The file is too big. I would like to know which approach from the given below give bettr perfomance by datastage.# Sample Line from file AAA2008NEO BBB2007RAM Approach 1 Define 3 columns in the sequntial file stage and read data. Col1 char(3) Col2 Integer(4) Col3 char...

whts the use of generate xml chunk in the xml output stage

oopssssssssssssss

I will go for a workaround

My job has the following format. Seq File ------ Transformer -----Sequential file. I put a constraint in transformer to exclude some type of data from source. Let suppose, if all the data in source is getting rejected by my constraint in the transformer, I don't want the target file to be created. B...

awesome!!

fine

GOT MY ANSWER!

tHANKS