Search found 56 matches
- Thu Feb 20, 2014 9:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Question about lookup
- Replies: 8
- Views: 3826
- Wed Feb 19, 2014 3:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Question about lookup
- Replies: 8
- Views: 3826
- Wed Feb 19, 2014 2:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Question about lookup
- Replies: 8
- Views: 3826
asorrell.....Thanks !! Well, here I want to know functionality how it works. At look-up stage options are continue , continue... So it will not fail now. When I am doing IF NUM1>0 THEN 'Y' ELSE 'N' at Xtrm....how does Datastage validates..... When mismatches NUM1 will be spaces....then space >0 will...
- Wed Feb 19, 2014 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Question about lookup
- Replies: 8
- Views: 3826
Question about lookup
I have a question on lookup. For both Source and lookup, I have Oracle Enterprise stage and after lookup, a transformer is there. In the transformer there is code: IF NUM1>0 THEN 'Y' ELSE 'N' NUM1 is coming from lookup stage and is is Char / Not Null. My question is about what happens when the data ...
- Tue Nov 26, 2013 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot stage in Datastage 9.1
- Replies: 5
- Views: 5990
- Tue Nov 26, 2013 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot stage in Datastage 9.1
- Replies: 5
- Views: 5990
vertical pivot stage in Datastage 9.1
Hello Everyone, Input ---------------------------- ST_ID CT_YS CT_ID ------------------------------ 1 XY1 100 1 ZX1 200 1 YZ1 400 1 YZ1 300 1 YZ1 100 Expected Output ------------------------------- ST_ID XY_ID ZX_ID YZ_ID ------------------------------------------------------------ 1 100 200 400 1 1...
- Thu Oct 24, 2013 12:46 pm
- Forum: General
- Topic: Trim function
- Replies: 3
- Views: 2041
- Thu Oct 24, 2013 11:57 am
- Forum: General
- Topic: Trim function
- Replies: 3
- Views: 2041
- Thu Oct 24, 2013 10:51 am
- Forum: General
- Topic: Trim function
- Replies: 3
- Views: 2041
Trim function
Hello Everyone, My input data comes like "ASH" or SRI"RAM" when its loading to file ......its loading as ""ASH"" or "SRI"RAM"" I want to trim " (quotes)..... expected output is -------------------------------- "ASH" "SRI...
- Mon Oct 07, 2013 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job failed
- Replies: 2
- Views: 1880
Datastage job failed
we got the following ERROR: 049 22:51:52(000) <main_program> Parameter specified but not used in flow: DSProjectName [osl\osl.C:623] When we restarted it RAN fine.........but I am not sure how it worked......did anyone faced this Issue ? how u guys sorted it out ? I just want to know why this caused...
- Thu Aug 22, 2013 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ins Upd Del in one Stage
- Replies: 11
- Views: 5196
- Thu Aug 22, 2013 7:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ins Upd Del in one Stage
- Replies: 11
- Views: 5196
- Wed Aug 21, 2013 12:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ins Upd Del in one Stage
- Replies: 11
- Views: 5196
- Wed Aug 21, 2013 11:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ins Upd Del in one Stage
- Replies: 11
- Views: 5196
Ins Upd Del in one Stage
Hello Every one, I need a logic ..... I have a input file...........It consists of Inserts, Update's and Delete. What I mean is ,suppose if I have 100 records in file........It should be load in to the table sequentially (Either Inserts, Update's or Delete have to commit one after and another) Can a...
- Wed Aug 14, 2013 11:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to load time stamp
- Replies: 3
- Views: 2517