IT WORKED !!!!
@qt_ky : Thank you very much. Appreciate ..
Warm Regards,
Kumarjit.
Search found 99 matches
- Wed Jul 06, 2016 11:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pattern matching in Sparse lookup
- Replies: 2
- Views: 3097
- Wed Jul 06, 2016 5:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pattern matching in Sparse lookup
- Replies: 2
- Views: 3097
Pattern matching in Sparse lookup
Hi. I am trying to do a SPARSE lookup from a reference table(SQL Server, accessed by ODBC Connector stage) and the actual lookup logic is given below: SELECT COUNT(1) AS TESTCNT FROM TEST WHERE SUBSTRING(TEST_ID,1,6)=orchestrate.SRC_CD The column SRC_CD is coming from the stream link and the record ...
- Thu May 19, 2016 7:23 am
- Forum: General
- Topic: Migrate server routines to parallel
- Replies: 7
- Views: 5410
- Thu May 19, 2016 5:49 am
- Forum: General
- Topic: Migrate server routines to parallel
- Replies: 7
- Views: 5410
Migrate server routines to parallel
Hi there. I am undertaking a project assignment to convert a set of Server Routines into parallel ones, but I have never worked on routines before, and I am totally unaware of the server routine constructs. The logic of one of the server routines that I need to replicate is given below. This routine...
- Wed Apr 13, 2016 8:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to perform multiple if else validation in a transformer
- Replies: 5
- Views: 5933
How to perform multiple if else validation in a transformer
Team. Please help me understand this issue(which might look easy). I am performing checks on three input columns coming from A fixed width source file to validate whether any of these columns Has whitespaces. For that I use the following if else in a transformer Stage variable. If Len(trim(col1))=0 ...
- Thu Apr 07, 2016 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating records in ascending sequence
- Replies: 10
- Views: 9483
- Wed Apr 06, 2016 11:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating records in ascending sequence
- Replies: 10
- Views: 9483
@Ray: As Craig has mentioned, the output would be a sorted column(col2), values of which will be continuous and range from min(col1) to max(col1). @Craig: Looping does work good in this case where the input is already sorted in ascending order , but what if the input column values are staggered(like...
- Wed Apr 06, 2016 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating records in ascending sequence
- Replies: 10
- Views: 9483
Generating records in ascending sequence
Hi. I have a source file with a single input column in it. A sample input might look like: Col1 1 8 4 5 7 3 10 My requirement is to get a single column output(say Col2), with record values ranging between min(col1) and max(col1), and in a ascending order Col2 1 2 3 4 5 6 7 8 9 10 One approach that I...
- Sun Apr 03, 2016 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic vertical pivot issue
- Replies: 14
- Views: 9156
- Sun Apr 03, 2016 1:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic vertical pivot issue
- Replies: 14
- Views: 9156
- Sat Apr 02, 2016 6:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic vertical pivot issue
- Replies: 14
- Views: 9156
Earnest thanks for all the help. I think that I can get over this, provided that I'm abble to address the issue below. This is the lone step that's standing between me and success, and I seek all your help on it. A sample input is: account_00 account_01 account_02 1001 1001 1002 1003 1003 1003 The o...
- Mon Mar 28, 2016 10:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic vertical pivot issue
- Replies: 14
- Views: 9156
- Mon Mar 28, 2016 1:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic vertical pivot issue
- Replies: 14
- Views: 9156
- Wed Mar 23, 2016 12:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic vertical pivot issue
- Replies: 14
- Views: 9156
Dynamic vertical pivot issue
Hi. My input is as follows: account# currency category fee amount 1001 USD Investment_Retail 100 1001 CAD Equity 200 1001 CHY Group_Liquidation 300 1002 USD Investment_Retail 400 1002 CHY Group_Liquidation 500 The output expected is: account# currency Investment_Retail Equity Group_Liquidation 1001 ...
- Wed Nov 25, 2015 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with external source stage
- Replies: 2
- Views: 2696