Search found 21 matches
- 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...
- 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...
- Tue Jul 13, 2010 12:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is it possible?
- Replies: 5
- Views: 2116
Re: Is it possible?
Yes you can
- 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
- 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
- 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.
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.