Search found 155 matches
- Wed May 22, 2013 6:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Internal Error - Aggregator Stage.
- Replies: 3
- Views: 3107
Hi Ray, It's my mistake.I have not properly migrated the job that creates the dataset [this dataset has the column for aggregation] and moreover the developer has typed the column in the aggregator stage rather the selecting it from the listbox.I have corrected it and ran the job it worked fine. I h...
- Tue May 21, 2013 11:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Internal Error - Aggregator Stage.
- Replies: 3
- Views: 3107
Internal Error - Aggregator Stage.
Hi All, Issue:-Below is the dump I received when I try to run the job in production. It uses a dataset,aggregator,dataset stage. I need to calculate the Maximum value of a date column group by a Column[No composite grouping keys]. I ran the same code with the same volume of data in Dev, the code is ...
- Tue May 14, 2013 5:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Upsert Statement
- Replies: 5
- Views: 2827
- Sun Apr 21, 2013 9:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Upsert Statement
- Replies: 5
- Views: 2827
Upsert Statement
Hi All, Requirement:A Delta extract will change to full extract at a specfic time period[Eg:say every 3 months].It will have the same version of the records in my datawarehouse only during that time period. My approach:I am changing the write mode from insert to upsert in my oracle connector stage ....
- Thu Jul 19, 2012 6:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wave Generator Stage
- Replies: 4
- Views: 11254
Thanks Ernie and Craig.Valuable information. My requirement is similar[performing inserts,updates and rejects from the same transformer source] but not exactly real time in nature. Also, I need to wait for the unit of work[rejects] to get completed for the job abort to occur and at the same time sto...
- Wed Jul 18, 2012 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wave Generator Stage
- Replies: 4
- Views: 11254
Wave Generator Stage
Hi All, Kindly help me in understanding the concept of the wave generator stage. Requirement: ======== Need to abort the job after inserting 'n' number of records into the reject table. Design: ===== 1.Filtered the records based on the reject criteria and threshold and inserted into the reject table...
- Tue Jul 03, 2012 9:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rollbacking transactions
- Replies: 1
- Views: 1422
Rollbacking transactions
Hi, Small clarification. My understanding:If we issue two different DML statements into two different Oracle Connectors then ideally depending upon the commit interval which I set in each Oracle Connectors, the transactions will get commited even if the job fails. Correct me If i have misunderstood....
- Wed Jul 08, 2009 11:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pros and Cons of I/O
- Replies: 5
- Views: 3061
Thanks Andy,kim I don't see any open endness in the question.It was very specfic that staging the jobs in intermediate datasets allows modularity in design but resource usabilty,I/O speed need to be optimized.If anyone has done this optimization earlier are most welcome to share their views. Andy:-I...
- Wed Jul 08, 2009 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pros and Cons of I/O
- Replies: 5
- Views: 3061
Pros and Cons of I/O
Hi All, We are in the process of standardizing datastage design techniques. When it comes to modularity, I/O issue was raised. Can I get some inputs on what are the pros and cons of modular designing versus designing in one single job in terms of speed and resources. Since modular designing involves...
- Mon May 11, 2009 6:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Like Operator in datastage
- Replies: 4
- Views: 17063
- Mon May 11, 2009 4:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Like Operator in datastage
- Replies: 4
- Views: 17063
Like Operator in datastage
Hi All, A small clarification.Is there any functions or suggestions to implement the LIKE operator in datastage. Eg:-Select col1,col2 from table1 where col3 LIKE %ABC%. I am converting some sql scripts to datastage jobs,the issue is I have to implement the LIKE part also in datastage because the sou...
- Mon May 04, 2009 6:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings
- Replies: 2
- Views: 2325
Warnings
Hi All, I am pivoting some columns into rows using pivot. Anybody has encountered this warning. Invalid character(s) ([xA9]) found converting string (code point(s): IBM Confidential, OCO Source Materials, [xA9] Copyright IBM Corp. 2006. All Rights R...) from codepage UTF-8 to Unicode, substituting. ...
- Fri Mar 06, 2009 6:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Migration problem from 8.0 to 8.1
- Replies: 8
- Views: 4485
- Fri Mar 06, 2009 3:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Migration problem from 8.0 to 8.1
- Replies: 8
- Views: 4485
Thanks Sai, Yes I did view the data it got viewed properly. couple of other testing also I have done The query has 5 union queries. 1.If I remove all the unions then the job runs fine 2.Also, I introduce only one union in next testing, then the job is not getting completed. Anything can figured out ...
- Fri Mar 06, 2009 2:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Migration problem from 8.0 to 8.1
- Replies: 8
- Views: 4485