Hello Folks
I have a source as DB and i'm getting NULL values from that so i want to replace them with char value eg(XXX) how can i perform it?
Thanks
Search found 35 matches
- Tue Oct 08, 2013 3:58 am
- Forum: General
- Topic: How to handle NULL values coming from DB side?
- Replies: 5
- Views: 2601
- Tue Sep 10, 2013 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we do performance tuning at buffer-level
- Replies: 0
- Views: 1298
Can we do performance tuning at buffer-level
Hello Folks
How can we do performance tuning at buffer level,please explain in detail
Thank You
How can we do performance tuning at buffer level,please explain in detail
Thank You
- Wed Sep 04, 2013 11:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregation By row-wise
- Replies: 4
- Views: 2339
- Wed Sep 04, 2013 10:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic to count repeated rows
- Replies: 9
- Views: 4549
- Wed Sep 04, 2013 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregation By row-wise
- Replies: 4
- Views: 2339
- Wed Sep 04, 2013 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregation By row-wise
- Replies: 4
- Views: 2339
Aggregation By row-wise
Hello Folks I have a scenario similar to this Source Target Dept,sal Count 10,100 100 10,110 210 20,200 200 20,210 410 How to perform this. Thanks
- Wed Sep 04, 2013 10:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic to count repeated rows
- Replies: 9
- Views: 4549
- Wed Sep 04, 2013 3:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic to count repeated rows
- Replies: 9
- Views: 4549
Logic to count repeated rows
Hello Folks I have a scenario similar to this Source Target 10 1 10 2 10 3 20 1 20 2 30 1 30 2 and i want the target as mentioned above
- Thu Jul 25, 2013 12:41 am
- Forum: General
- Topic: How to remove alphanumeric characters using transformer?
- Replies: 4
- Views: 2443
- Thu Jul 25, 2013 12:15 am
- Forum: General
- Topic: How to remove alphanumeric characters using transformer?
- Replies: 4
- Views: 2443
How to remove alphanumeric characters using transformer?
Hi Folks
i have a source like this
ID
122133@324
$324234423
$324342346
i want to remove those alphanumeric characters,how can i achieve it.
Thanks
i have a source like this
ID
122133@324
$324234423
$324342346
i want to remove those alphanumeric characters,how can i achieve it.
Thanks
- Sun Jul 21, 2013 12:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What does 'output row only once' will do in filter
- Replies: 15
- Views: 8008
Hi ray I got error like this in log file Filter_1:Error occured during initialize from Args() Filter_1:Parse error;Expected comparision operator('>','<')after literal,got:<eof>.(....) main_program:Creation of a step finished with status = Failed see if i give condition like below it works fine where...
- Sat Jul 20, 2013 11:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What does 'output row only once' will do in filter
- Replies: 15
- Views: 8008
- Fri Jul 19, 2013 12:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What does 'output row only once' will do in filter
- Replies: 15
- Views: 8008
i have input table like this cust_id,cus_name,deptno 1,uma,10 2,varun,20 3,siva,30 1,rathode,40 and in filter i mentioned first where condition as 1) where =deptno=10 to output link 0 and second where clause as 2)Where =deptno=10 to output link 1 and third where clause as 3)Where = deptno=20 to outp...
- Fri Jul 19, 2013 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What does 'output row only once' will do in filter
- Replies: 15
- Views: 8008
- Thu Jul 18, 2013 9:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What does 'output row only once' will do in filter
- Replies: 15
- Views: 8008
Re: It will not pass the record to second where condition...
Tats superb explanation.I got it.But as you mentioned in second condition that we have to write deptno in(10,20,30) when i'm writing this condition in filter compilation is going fine but while i run the job i'm getting error how come?? i wrote like First condition deptno = 10 Second condition deptn...