DSXchange

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

Hello Folks

How can we do performance tuning at buffer level,please explain in detail




Thank You

Hello Andy

Thanks for your solution, it worked perfectly!

Hello Chullet


i'm not getting wat you are saying



Thanks

Hello Parsson

I took one stagevar for deptno and given logic like this

StageVar = deptno

If deptno = StageVar Then S1+Sal Else Sal --------------- S1

but i'm not getting the expected result


Thanks

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

Hello Eric

I got the solution by using the below mentioned logic

IF deptno = deptno Then deptno+1 Else 1

this one gave me exact solution.

Thanks for your reply

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

hey ray

sorry for that i dint noticed that properly i want to remove those symbols like @,$

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

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...

Hi ray

Failure means when you compile you get blue line when you run if success green will come else red for failure so like that i got red line.

Any how i find another solution like in filter we can keep like deptno <=40 where it will cover all the dept's.



Thanks.

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...

Hey Ray

I tried your solution but it din't worked.Any other way?




Thanks

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...