Search found 212 matches
- Tue Feb 14, 2012 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage Repetition Element Issue
- Replies: 5
- Views: 3867
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...
- Thu Feb 09, 2012 2:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage Repetition Element Issue
- Replies: 5
- Views: 3867
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...
- Wed Feb 08, 2012 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage Repetition Element Issue
- Replies: 5
- Views: 3867
XML Input Stage Repetition Element Issue
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 ...
- Wed Sep 14, 2011 2:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Where is "Key Change" option in the new transforme
- Replies: 3
- Views: 2678
Where is "Key Change" option in the new transforme
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...
- Tue Apr 26, 2011 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Carriage Return from the end of the file
- Replies: 4
- Views: 5726
- Tue Apr 26, 2011 11:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Carriage Return from the end of the file
- Replies: 4
- Views: 5726
Remove Carriage Return from the end of the file
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...
- Thu Feb 17, 2011 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the group of jobs using the same Dataset
- Replies: 4
- Views: 5173
- Wed Feb 16, 2011 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the group of jobs using the same Dataset
- Replies: 4
- Views: 5173
How to find the group of jobs using the same 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
Thanks
- Mon Nov 23, 2009 10:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Load Problem
- Replies: 5
- Views: 3359
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...
- Mon Nov 23, 2009 9:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Load Problem
- Replies: 5
- Views: 3359
Oracle Load Problem
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 ...
- Mon Mar 23, 2009 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split Data into different files
- Replies: 4
- Views: 3741
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 ...
- Mon Mar 23, 2009 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split Data into different files
- Replies: 4
- Views: 3741
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...
- Fri Mar 20, 2009 9:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split Data into different files
- Replies: 4
- Views: 3741
Split Data into different files
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...
- Thu Mar 19, 2009 3:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate Sequential Number using Parallel Transformer
- Replies: 9
- Views: 10281
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...
- Thu Mar 19, 2009 11:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate Sequential Number using Parallel Transformer
- Replies: 9
- Views: 10281