Input --> Aggregator --> Transformer --> Output
- Get Min and Max from aggregator
- Use Max in Transformer looping and generate all the values
Search found 592 matches
- Thu Apr 07, 2016 2:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating records in ascending sequence
- Replies: 10
- Views: 9117
- Tue Dec 22, 2015 3:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aggregation rows/ summary rows
- Replies: 2
- Views: 3855
- Fri Dec 04, 2015 2:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup scenario with duplicate keys in the reference table
- Replies: 2
- Views: 3486
- Fri Dec 04, 2015 2:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field wise record count for different Files
- Replies: 4
- Views: 4260
Source --> Transformer1 --> Pivot Enterprise --> Transformer2 --> Aggregator --> Target Transformer1 : Create derivation like this for all your fields wherein hard-code your field name in Else If NullToEmpty(Field1) = '' Then '' Else 'Field1' Pivot Enterprise : Do horizontal pivoting with Derivation...
- Wed Apr 15, 2015 2:43 am
- Forum: Cognos (IBM BI)
- Topic: Migrate Cognos Decision stream and Data Manager to Datastage
- Replies: 2
- Views: 21006
Migrate Cognos Decision stream and Data Manager to Datastage
Hi Members,
Any one has experience in the following migations?
IBM Cognos Decision Stream V7.1 to IBM Infosphere DataStage v11.3 &
IBM Cognos Data Manager V10 to IBM Infosphere DataStage v11.3
Any help is much appreciated
Thanks,
Anbu
Any one has experience in the following migations?
IBM Cognos Decision Stream V7.1 to IBM Infosphere DataStage v11.3 &
IBM Cognos Data Manager V10 to IBM Infosphere DataStage v11.3
Any help is much appreciated
Thanks,
Anbu
- Wed May 21, 2014 5:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extended property to Unicode for Varchar cols in Schema file
- Replies: 1
- Views: 2768
Extended property to Unicode for Varchar cols in Schema file
I have to parse Spanish Characters from my input( TSV/Excel ). RCP is set on source sequential file stage. Can you please advice how to set Extended property to Unicode for Varchar cols in Schema file?
- Tue May 20, 2014 3:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic sequential file name generation
- Replies: 13
- Views: 11245
Try this command in filter
Code: Select all
awk -v dt=$(date +"%Y%m%d") ' { print > dt"_data.txt" } '
- Mon Apr 14, 2014 11:09 pm
- Forum: General
- Topic: No Reject Rows but also create empty Reject File
- Replies: 3
- Views: 3700
Reject files are always created. Use an after-job subroutine ExecSH or ExecSHSilent to execute rm command to delete reject file if it is empty
Code: Select all
if [ ! -s /Path/Reject_file ] ; then rm /Path/Reject_file; fi
- Mon Apr 14, 2014 2:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Query
- Replies: 3
- Views: 2795
Are you selecting only two rows?
Code: Select all
Select empno,NULL,salary from emp where Ename =Peter
Union All
select empno,salary,NULL from emp where Ename=Reddy
- Mon Apr 14, 2014 2:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looking for effective solution for sum
- Replies: 6
- Views: 4033
- Wed Apr 09, 2014 7:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when converting column overflows decimal datatype
- Replies: 7
- Views: 13656
- Wed Apr 09, 2014 7:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading Integer in Db2 issue
- Replies: 3
- Views: 4002
- Wed Apr 09, 2014 7:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when converting column overflows decimal datatype
- Replies: 7
- Views: 13656
- Wed Apr 09, 2014 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when converting column overflows decimal datatype
- Replies: 7
- Views: 13656
- Wed Apr 09, 2014 6:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when converting column overflows decimal datatype
- Replies: 7
- Views: 13656