Equalient DataStage function for oracle ceil

[raj158347]

Dear All,
I want to check the below condition...
Like the value
$0 to $100000 output 01
$10001 to $20000 output 02
$20001 to $30000 output 03
$30001 to $4000 output 04 etc....


So i need the equalient dataStage function for oracle ceil

Thanks in advance for your help..

Regards
Raj

[ray.wurlod]

How would you do that with ceil ?!!

Try

Code: Select all

Mod(InLink.TheColumn,10000) - 1

[raj158347]

How would you do that with ceil ?!!

Try

Code: Select all

Mod(InLink.TheColumn,10000) - 1

...

thanks for your kind reply..Sorry actualy i need if the value like below
$0 to 100000 output 01
$100001 to 200000 output 02
$20001 to 300000 output 03 so if i use ceil function i can get the nearest greatest for the value like ceil (100001/10000) output will be 2 as you know.Excatly i want to do the same.

Thanks & Regards
Raj

[Mayur Dongaonkar]

This can be achieved by using Switch stage.

[ray.wurlod]

You changed your specification. My solution changes only by losing its "- 1". You can use the Fmt() function to enforce leading zero.

I remain curious to learn how you would generate these values using ceil without any other arithmetic (since you did not mention any).

Switch stage is not available in server jobs and, in any case, would not generate the value that the OP seeks.

[raj158347]

Dear All ..
Thanks for your kind reply...
By using the following code + FMT function it is solved

IF WKLIABUSD = 0 THEN
DIV = 0
QUAS = 1
END
ELSE
DIV = DIV(WKLIABUSD,WKDIVI)
QUAS = WKLIABUSD/WKDIVI
END

IF QUAS > DIV THEN
Ans = DIV+1
END
ELSE
Ans = DIV
END

WKLIABUSD is the value
WKDIVI is divser value

Eg :
WKLIABUSD 98000001
WKDIVI 1000000
Ans is 99


Regards
Raj

[ray.wurlod]

You might like to mark the thread as Resolved, then.