Search found 92 matches
- Mon Apr 02, 2012 1:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Group Determination
- Replies: 2
- Views: 1584
Group Determination
I need help regarding group ditermination. My input looks like this. the first 3 columns are my key. 10,20,30,A 10,20,30,X 10,20,40,B 10,20,50,Y 10,20,50,Z 10,20,60,D My output need to be 1st o/p : 10,20,30,A 10,20,30,X 10,20,50,Y 10,20,50,Z 2nd o/p 10,20,40,B 10,20,60,D I can do this by using the c...
- Tue Feb 21, 2012 9:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Roll back Settings
- Replies: 2
- Views: 1758
Re: Teradata Connector Roll back Settings
Hi Felix,
It doesnt work. I think record count only matters when it is immediae mode.
thanks
It doesnt work. I think record count only matters when it is immediae mode.
thanks
- Fri Jan 27, 2012 1:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Roll back Settings
- Replies: 2
- Views: 1758
Teradata Connector Roll back Settings
Do we have any property in Teradata CONNECTOR to Roll back the mload transactions, if there is a partial load
- Mon Oct 17, 2011 8:26 pm
- Forum: IBM QualityStage
- Topic: Quality Stage Reference match
- Replies: 4
- Views: 5390
- Mon Aug 29, 2011 11:50 am
- Forum: IBM QualityStage
- Topic: Match specification Run Error
- Replies: 3
- Views: 7038
Re: Match specification Run Error
I got the below error , when combining two sources of customers ,
two customer data sets I made to one using funnel size . i renamed column name in both the links but forgot to change the legths.
i chaged the lengths to have same in both the links then this issue resolved.
two customer data sets I made to one using funnel size . i renamed column name in both the links but forgot to change the legths.
i chaged the lengths to have same in both the links then this issue resolved.
- Wed Mar 17, 2010 2:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Route one of Duplicates based on condition
- Replies: 9
- Views: 5645
Have a lookup on the first set where STATUS='Removed' with the second set, if you find any record then PASS this records to an Sequential Stage which would be your STATUS=IMPLEMENTED records and wherever you won't find PASS them to a Reject Link which would be your STATUS=REMOVED records Transformer...
- Wed Mar 17, 2010 2:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Route one of Duplicates based on condition
- Replies: 9
- Views: 5645
- Tue Mar 16, 2010 1:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with loading "few" non english characters in
- Replies: 6
- Views: 10644
- Fri Jan 29, 2010 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190
- Thu Jan 28, 2010 2:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190
yup Chulett, Tables has been partioned and I am reading from single partition. but I am using parallel degree concept and trying to read prallel. SELECT /*+ PARALLEL(gl.tgltran, 35) */ CACCOUNT, EFFDATE, ENTITY, AU, APPLICATION_ID, SOURCE_ID, TXN_AMT, DEBIT_CREDIT, SERIAL_NUMBER, WORK_DATE, BATCH_NU...
- Thu Jan 28, 2010 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190
- Thu Jan 28, 2010 1:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190
- Wed Jan 27, 2010 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190
if you see below log from director, it says it's using 4 nodes main_program: This step has 1 dataset: ds0: {op0[4p] (parallel GL001P) => /opt/IBM/data/drm_fy_datamart/temp/GL001P.ds} It has 1 operator: op0[4p] {(parallel GL001P) on nodes ( node1[op0,p0] node2[op0,p1] node3[op0,p2] node4[op0,p3] )} I...
- Wed Jan 27, 2010 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190
Thanks for your response Ray. how to program in stage to utilise 4 node configuration while reading data from oracle table partition, Ray- are you trying to say though datastage has 4 node configuration but orace EE stage can't utilise parallelisam and it will read data with only one node. Does it m...
- Wed Jan 27, 2010 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle plugin not reading parallel
- Replies: 15
- Views: 9190