DSXchange

Since I am a premium member now, I add another question relating to this topic. I was able to parse out the optional data at the lowest granular level. Now I am facing another challenge that I need to regroup the data from other granular levels into one table. Optional data is highlighted in bold in...

I am sorry I cannot see your answer because I don't have premium account. Following is the XPath for the lowest repeating element in my XML. The XPath highlighted in bold is the one that is optional /RoutingMessageEnvelope/RoutingInputMessage/MessagePayload/paymentOrderRemittanceAdviceRequest/reques...

I am trying to parse an XML file using XML Input stage. It is a complex XML structure. I imported the related XSD and namespace code into the XML input stage. My problem is that I am unable to determine the Repitition key in my XML ? I thought, in order to get everything from the XML input stage, I ...

I read on the following blog http://it.toolbox.com/blogs/infosphere/ten-reasons-why-you-need-datastage-85-42312 by Vincent McBurney that the new transformer in the DS 8.5 gives the key change option but I could not locate this new property in the new transformer stage. I saw one new thing though, th...

I have already tried various Sequential file options but it did not help. I am looking for a UNIX command to fix this issue. Following is the scenario. I have a file called "file1" which has the following content. abc xyz 123 etc etc etc <-------------------- Blank line to remove How do I ...

Hello All I am producing a fixed width file with a carriage return in the last column of each record in the file. The business wants carriage return on all other records except the last record. Can anyway suggest me how can I remove the carriage return at the EOF. If possible, I don't want to remove...

Thanks Ray

That is something I didn't knew before. How about if I do not save the dataset table definition. Can we still search the job names using this (unsaved table definition) dataset ?

I am trying to change the datatypes on a dataset which is used by multiple jobs. I manually found 3 jobs which are using this dataset. Is there a way in Datastage that we can find all the jobs using a particular dataset ?

Thanks

When I truncate the table and run fresh data, the job runs fine and records get uploaded into the table, but when I rerun the job to process another months data it loads some data and aborts complaining about the Index parition error mentioned earlier. We cannot recreate the index partition after th...

I am trying to load into Oracle using Oracle Enterprise stage. The write method is load. The target table is indexed on three fields plus it is partitioned by 12 months. When I try to load/append the data (sequentially) to this table the job aborts complaining about the index partition that are not ...

The problem was memory limitation. The target directory did not had enough memory for the file to be uploaded. The output file was sized 15G and the directory had just 10G of space. So the mismatch of the directory size and the file size had actually caused an abort. I used the following command to ...

The problem was memory limitation. The target folder did not had enough memory for the file to be uploaded. The output file was sized 15G and the folder had just 10G of space. So the mismatch of the folder size and the file size had actually caused an abort. I used to the following command to determ...

Hi All I am trying to achieve a new logic to produce flat files. The current design of the job extracts the data from Oracle Database around 150 Million records and then loads into a sequential file for the business to use for reporting. I tried to load the complete 150 Million into the Sequential f...

Sorry Guys, Actually I ran into problems again. I was trying to run the job with different number of input records/dataset. The logic works well with limited data say around 900,000 input records but when I run the job using 1 million records or more, the sequence generation is broken and only one n...

Thanks a bunch kryt0n and Ray, it actually works. I did a fumble in the initialization part of the stage variable. My bad.