and use only Input--->Remove Dups--->Output.
Use the input column sorting/partitioning in Remove Duplicate stage. No need to use Sort Stage for your requirement.
Search found 88 matches
- Sat Feb 21, 2015 1:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort with remove Dups
- Replies: 5
- Views: 3964
- Sat Feb 21, 2015 1:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort with remove Dups
- Replies: 5
- Views: 3964
- Tue Jan 27, 2015 1:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting rows with data in the column header
- Replies: 4
- Views: 3394
1: Define two Stage Variables as svLoopControl and svColumns 2: svColumns = Delimited Column names and svLoopControl = Dcount function to get the total number of columns from svColumns with Delimiter Value. 3: Define two Loop Variable as lvCount and lvColumns. 4: lvCount = lvCount + 1 and lvColumns ...
- Tue Sep 09, 2014 11:43 am
- Forum: General
- Topic: LastrowinGroup function in datastage
- Replies: 4
- Views: 5830
- Thu Jan 30, 2014 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting lower case to upper case of first character
- Replies: 3
- Views: 3548
- Mon Jan 06, 2014 12:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Internal partitioning Issue
- Replies: 2
- Views: 3495
Hi Swathi,
Please set APT_NO_PARTSORT_OPTIMIZATION as described here https://www-304.ibm.com/support/docview ... wg21517119
Hope this will help you.
Thanks
Please set APT_NO_PARTSORT_OPTIMIZATION as described here https://www-304.ibm.com/support/docview ... wg21517119
Hope this will help you.
Thanks
- Sun Jun 30, 2013 3:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to generate serial number
- Replies: 9
- Views: 3665
- Thu Jun 27, 2013 1:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Columns to rows
- Replies: 5
- Views: 2800
If you are using DS 8.5 or above, consider using Transformer Loop function. For reference check http://newtonapples.com/datastage-trans ... looping-1/
Or if you are using DS 8.1 try using key break logic viewtopic.php?p=423754
Or if you are using DS 8.1 try using key break logic viewtopic.php?p=423754
- Thu Jun 20, 2013 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IsValid function
- Replies: 4
- Views: 4835
Use this code:
This will check mylink.mystring for Numeric Values (0-9) only. If true it will return 1 else 0.
Hope this helps
Code: Select all
Num(Convert(".","A",mylink.mystring))
Hope this helps
- Thu Jun 06, 2013 12:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alternate logic required ?
- Replies: 11
- Views: 5799
- Wed Jun 05, 2013 1:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alternate logic required ?
- Replies: 11
- Views: 5799
One options is to use Unix script in before job subroutine and get the total of all 4 amount column. For this you can use something like awk '$6+=$5+=$4+=$3' where $n is the column number with amount fields. This will remove your first transformer. You will end up using one transformer to filter out...
- Mon May 06, 2013 1:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema File - Select few columns
- Replies: 4
- Views: 3095
- Mon Apr 01, 2013 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delimiter Issue in extracting file
- Replies: 9
- Views: 5542
- Wed Feb 06, 2013 2:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Why to use Copy Stage for single input and output.
- Replies: 7
- Views: 5321
- Tue Sep 25, 2012 12:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to pass current date as filename in datastage server
- Replies: 7
- Views: 16568