Search found 135 matches
- Thu Sep 05, 2013 11:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Different results in every run
- Replies: 5
- Views: 4141
- Thu Sep 05, 2013 12:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading same table in db by 2 different parallel jobs
- Replies: 5
- Views: 3950
Parallel inserts are allowed on the tables.Suppose that the table you mentioned is loaded by only one parallel job in your project and the job runs on 8 nodes.It is implicit that it is allowing 8 parallel insert statements. In your case the table is loaded by two jobs and assuming your job runs in 2...
- Mon Sep 02, 2013 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion from decimal(25,2) to decimal(14,2)
- Replies: 9
- Views: 6027
- Tue Aug 27, 2013 1:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML requirement
- Replies: 4
- Views: 2695
- Tue Aug 27, 2013 1:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Merging multiple rows into single row
- Replies: 11
- Views: 8015
Just to make sure nothing wrong in your derivation.Enable KeyChange Column in sort and write your derivation like
Code: Select all
svCurrent = If KeyChange=1 Then ColB:',':ColC Else svPrev:', ':ColB:',':ColC
svPrev=svCurrent
- Tue Aug 20, 2013 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting special characters
- Replies: 7
- Views: 6152
- Tue Aug 20, 2013 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with txt file
- Replies: 6
- Views: 4158
- Wed Aug 14, 2013 6:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strange issue while converting varchar to integer
- Replies: 5
- Views: 4233
- Tue Aug 06, 2013 3:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup_103,1: Field "ID" has keyprep export format
- Replies: 11
- Views: 9375
- Mon Jul 22, 2013 10:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate key with cyclic option
- Replies: 4
- Views: 3031
- Fri Jul 19, 2013 4:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get unique records ?
- Replies: 2
- Views: 2699
Split the Combined records from first 2 sources into two streams using copy stage and send one stream of the combined data from first 2 sources as reference to Lookup stage and use the third source as stream , perform look up on key and capture the rejects. Now send the other stream from copy stage ...
- Fri Jul 19, 2013 4:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk characters issue
- Replies: 2
- Views: 3081
Check if the link http://www-01.ibm.com/support/docview.w ... wg21587829 helps
- Wed Jul 10, 2013 4:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregation/Summation
- Replies: 9
- Views: 5913
- Wed Jul 10, 2013 3:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with state file
- Replies: 5
- Views: 4879
- Wed Jul 10, 2013 3:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Incorrect allignment while generating CSV file using DS job.
- Replies: 7
- Views: 4643