DSXchange

You can use a BASIC Transformer stage in a parallel job. To determine whether the value in InLink.code is in a particular range you can use Oconv(InLink.code, "R700,709;800,849;860,867;870,876;880,899") This will return the original value if code falls in any of those ranges, or "&qu...

The syntax is almost identical to what you already have, you basically replace the "CASE WHEN" with "IF". You'll need to change the NVL and IN verbs to DataStage equivalents, of course. And disregard the 'nested' part in this case, you just need one big one if-then-else. Is this...

Thanks for your inputs.
Sorry i have posted the actual requirement here in this link below.

viewtopic.php?t=140904

Thanks Chulett. But i have three columns AND 'ed above.
How can i use a nested if -then -else construct?
Did you mean to say if then else with stage variables?

Ray, How can i include three columns in your statement above?

Hi Pandeesh , there is an AND condition between three columns. If all of the three columns together satisfy the above codes, then reject Else pass.


Thanks Ray. I couldnt see your content for now. I just bought a membership, have to wait until it reflects..

Thanks Ray ,
I am using a parallel job here. Please tell me how to do this in parallel.
Datatypes are varchar for all. Data volume less than 10000 rows.

I have this case statement to be implemented in datastage: CASE WHEN ((NVL(a.code,'0') IN ('0','00','000')) OR (a.code BETWEEN '700' AND '709') OR (a.code BETWEEN '800' AND '849') OR (a.code BETWEEN '860' AND '867') OR (a.code BETWEEN '870' AND '876') OR (a.code BETWEEN '880' AND '899') ) AND ((NVL(...

I have values coming as above in three different columns. condition is something like column 1 column 2 column 3. 4 26 85 ------------>reject 00 4 null -------------->reject 3 26 85 --------------->pass If any of those values mentioned in the actual post satisfy the above condition i should reject t...

I dont have any run identifier in the job. I do use load and append option for the rows. BTW sorry for the late response.

I have a requirement. I need to exclude the ranges and values like below in datastage.
4-10
25-30
80-300
00
null

Any suggestions would be appreciated.


Thanks

Thanks much Jwiles.

I need to capture inserted ( to the Oracle EE stage as target) record count
after the job is finished and send it to the other table (oracle).
With using sequence or if possible without using sequence job.

Please help me with a suggestion.



Thanks,

Thanks Ray and Sura.

I have used two methods.

1) lookup (Reject option)

2) Outer join and filter


What do i do with main stream coming out of the lookup ? I have no use with it. Can i send it to copy stage as a target ?

Thanks Sura.

Did you mean to say-----

using full outer join in join stage
and filter where b.casenum and b.regno are null in transformer stage.
This is good idea.

How about in lookup?

I need to implement the below condition in lookup or outside of lookup. Assume 'a' and 'b' as two tables. a.casenum<>b.casenum and a.regno<>b.regno In the above case, I also need to know two different scenarios below. 1) Output columns ---> a.casenum and a.regno 2) Output columns ---> b.casenum and ...