Search found 21 matches

by Shaanpriya
Tue Jul 13, 2010 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to specify Sparse Lookup
Replies: 2
Views: 2755

Re: how to specify Sparse Lookup

Iam new to datastage and i came to know about sparse lookup. I tried to see that option in the Look Up Stage but i coudnt find it. Can you please specify me in brief how to specify and where in the lookup stage. The lookup type can be specified in the Lookup type field in the source category of the...
by Shaanpriya
Tue Jul 13, 2010 12:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Records Dropping because of 0 values
Replies: 5
Views: 2542

Re: Records Dropping because of 0 values

Hi Experts, i am doing calculations in minutes and $ values, i am getting 0 values . it has to send these records with acct_number and amount 'zero values' to target. but it's droping. tried with datatype "decimal' and 'numeric' also , still records are doped. here is the log : "Field 'ED...
by Shaanpriya
Fri May 14, 2010 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checking jobstatus
Replies: 4
Views: 1650

You can put DS Macros in an after job script and get the status.
by Shaanpriya
Thu Oct 09, 2008 11:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Equivalent of the SIGN Function in Oracle
Replies: 2
Views: 1829

Wow... Thanks Ray for taking the time to reply for the query..
by Shaanpriya
Wed Oct 08, 2008 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Equivalent of the SIGN Function in Oracle
Replies: 2
Views: 1829

DataStage Equivalent of the SIGN Function in Oracle

Hi all,
I have this requirement in my project wherein I am supposed to use the SIGN function in order to find if the augument (Number) is positive , negative or zero. Does anyone know what function I can use in Parallel jobs to attain the same funtionality.

Thanks,
Priya.