Search found 126 matches
- Mon Apr 17, 2017 8:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partial records are loaded while joining
- Replies: 2
- Views: 2834
Partial records are loaded while joining
Hi All, I have two dataset in my prod job and doing left outer join based on the column(GL_PROD,GL_ACCT). The key columns datatype is Decimal. After completing the run, out of two records only one record was populated into target datset even though key column values are matched. Due to that,unable t...
- Thu Jul 09, 2015 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WaitForWriteSignal(): Premature EOF on node
- Replies: 2
- Views: 4592
WaitForWriteSignal(): Premature EOF on node
Hi All, Our jobs are running in production past 3 years without any issue. Today one of the job got failed due to below captioned reason. Not sure why it got failed. Kindly advice on how to fix this issue. Aggregator_198.lnkFund_Sort,1: Fatal Error: waitForWriteSignal(): Premature EOF on node PM094S...
- Wed Jan 14, 2015 1:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Tuning
- Replies: 2
- Views: 2147
Performance Tuning
Hi All, One of my job is production taking more than 3 Hrs 50 min to load the data into the data set. The design is very simple 1. Incremental source file extract the records having 21 million records from sequential file to load the data into data set. 2. The above loaded data set having look up wi...
NLS...
Hi All,
Today when I run the sequencer, one of the job got below mentioned warnings.
"DataStage Job 176 Phantom 5764 Program "DSD.ODBEvent": Line 1519, Could not locate NLS map . DataStage Phantom Finished"
Can you tell me how to fix this warning?
Today when I run the sequencer, one of the job got below mentioned warnings.
"DataStage Job 176 Phantom 5764 Program "DSD.ODBEvent": Line 1519, Could not locate NLS map . DataStage Phantom Finished"
Can you tell me how to fix this warning?
- Thu Aug 22, 2013 9:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Decimal Issue
- Replies: 2
- Views: 2505
- Thu Aug 22, 2013 7:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Decimal Issue
- Replies: 2
- Views: 2505
Decimal Issue
Hi, In my job one of the column name data type is Decimal(15,7). When I view the data in DB data comes in proper format like below COLUMN NAME ---------------- 2003.0000000 But when try to view the same column (data type is Decimal(15,7) ) in datastage data comes in below mentioned format. COLUMN NA...
- Wed Aug 07, 2013 6:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating date ranges
- Replies: 5
- Views: 4285
- Wed Aug 07, 2013 3:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating date ranges
- Replies: 5
- Views: 4285
Creating date ranges
Hi, In one of my job my date format like below 2011-07-03 2011-08-03 2011-09-03 2011-10-03 2011-11-03 Now I need to compare the data between the current and previous data. I need to take first row date(2011-07-03) as my start date and the next row date need to load as a end date before that I have m...
- Tue Jul 09, 2013 4:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ds_nlsmap() - BCI NLS input mapping error
- Replies: 0
- Views: 1832
Re: ds_nlsmap() - BCI NLS input mapping error
I fixed the problem. Now job is running fine. I changed the NLS setting to "NONE".
Thanks to everyone.
Thanks to everyone.
- Thu Mar 07, 2013 10:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot rows
- Replies: 12
- Views: 6023
Chulett, Why I asked for looping concept, I have to implement the same logic in another job and source table having 60 columns. It is really difficult for me to implement having 60 rows in the same job. That's why I asked how to implement the same logic using loop variables. Need output is: 1,2,3 2,...
- Thu Mar 07, 2013 8:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot rows
- Replies: 12
- Views: 6023
- Thu Mar 07, 2013 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot rows
- Replies: 12
- Views: 6023
I have 6 columns in the source table with data as follows. Source Data: COL1,COL2,COL3,COL4,COL5,COL6 A,B,C,D,E,F The output should be A,B,C B,C,D C,D,E D,E,F E,F,NULL F,NULL,NULL The output will have only 3 columns. The data should be like this. First row: first column, second column, third column ...
- Thu Mar 07, 2013 5:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot rows
- Replies: 12
- Views: 6023
Pivot rows
Hi All,
I need to implement one of the logic in my job. In the source table having 6 columns in one row and that row I need to be pivoted like I mentioned below.
Source table:
col1,col2,col3,col4,col5,col6
1,2,3,4,5,6
Output:
1,2,3
2,3,4
4,5,6
5,6,null
6,null,null
Any help is really appreciated.
I need to implement one of the logic in my job. In the source table having 6 columns in one row and that row I need to be pivoted like I mentioned below.
Source table:
col1,col2,col3,col4,col5,col6
1,2,3,4,5,6
Output:
1,2,3
2,3,4
4,5,6
5,6,null
6,null,null
Any help is really appreciated.
- Fri Dec 28, 2012 12:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TimeStamp
- Replies: 11
- Views: 5259
- Thu Dec 27, 2012 11:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TimeStamp
- Replies: 11
- Views: 5259