Search found 52 matches
- Tue Mar 12, 2013 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
- Tue Mar 12, 2013 4:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
- Tue Mar 12, 2013 3:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
No , it is in this format Row 1 of the file could be Key,Col2,Col3 Row 2 of the file could be Key,Col2,Col3 Row 3 of the file could be Key,Col2,Col3 or in this format Row 1 of the file could be Key,Col1,Col2 Row 2 of the file could be Key,Col1,Col2 or in this format Row 1 of the file could be Key,Co...
- Tue Mar 12, 2013 3:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
Hi From source we will receive 1 key column and out of 3 remaining columns only 2 columns ,that we are not sure which 2 columns out of 3 columns we receive. example if 3rd colums is not comming then we dont need to send those column to target.. thats way i mentioned all possible columns in schema fi...
- Tue Mar 12, 2013 3:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
- Tue Mar 12, 2013 3:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
- Tue Mar 12, 2013 2:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: replace function
- Replies: 6
- Views: 26667
Re: Replace a pattern in string
can u give one example how do u want to replace..
- Tue Mar 12, 2013 2:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Source file correction
- Replies: 2
- Views: 2495
Source file correction
Hi All,
i am extracting data from source file.Here i am getting some special character those are like some box characters... How can i remove those special characters from the file.
Can anybody help me on this...
Thanks..
i am extracting data from source file.Here i am getting some special character those are like some box characters... How can i remove those special characters from the file.
Can anybody help me on this...
Thanks..
- Tue Mar 12, 2013 2:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Time YYYYMMDD HH:NN:SS:SSSSSS format
- Replies: 5
- Views: 6583
- Tue Mar 12, 2013 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding schema file
- Replies: 16
- Views: 8418
Regarding schema file
Hi I have created schema file below format and i tried to run the job with 4 columns with data and it is working fine. i tried to run the job with 2 columns only but it is not running and it is throwing error for 3rd column delimeter is missing. can anybody suggest me how can i do . record {final_de...
- Mon Feb 11, 2013 5:51 am
- Forum: General
- Topic: Architectural difference between Datastage v8.1 & v8.5 &
- Replies: 1
- Views: 1978
Architectural difference between Datastage v8.1 & v8.5 &
Hi All,
Can anybody tell me what are all main architectural difference between Datastage v8.1, v8.5 & v8.7
Can anybody tell me what are all main architectural difference between Datastage v8.1, v8.5 & v8.7
- Thu Nov 15, 2012 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Space in decimal number
- Replies: 2
- Views: 1859
Space in decimal number
Hi all, I am genarating fixed with file and that file contains 2 columns. Uniq char(4),Amt decima(8,2) Output file i am getting is : aaaa 000001.12 bbbb 000011.23 Required Output should be without space: aaaa000001.12 bbbb000011.23 The problem here is Before decemal coumn i am getting one extra spac...
- Wed Sep 07, 2011 10:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Performance
- Replies: 4
- Views: 3782
Aggregator Performance
Hi,
In the job we are giving 19 crore data to aggregator stage,it is taking 3 hrs time.here we are giving sorted data and hash partitioned data to agg and method in agg is sort method..please let me know if i can reduce the time in any other manner..
Thanks,
Rajashekar.
In the job we are giving 19 crore data to aggregator stage,it is taking 3 hrs time.here we are giving sorted data and hash partitioned data to agg and method in agg is sort method..please let me know if i can reduce the time in any other manner..
Thanks,
Rajashekar.
- Thu Aug 04, 2011 10:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Viewing dataset
- Replies: 1
- Views: 1381
Viewing dataset
Hi All,
Can anybody te ll commnads to view the data in the dataset in unix.
Thanks in advance..
Can anybody te ll commnads to view the data in the dataset in unix.
Thanks in advance..
- Thu Jul 21, 2011 1:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Logic
- Replies: 3
- Views: 2061
Need Logic
HI Ray,
Thanks for the information ,cant we do in the 8.1 version.Please let me know any work around.
Thanks for the information ,cant we do in the 8.1 version.Please let me know any work around.