hello,
tell me the function which removes spaces from decimal
field?
Answers were Sorted based on User's Feedback
Answer / murali udayagiri
Generally the decimal field does't contain any spaces.
The below two are string functions.
1.decimal_lpad
2.decimal_strip
These can be used for
a)trim the spaces
b)Removing nondecimal
from string inputs.
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 2 Yes | 1 No |
How can you force the optimizer to use a particular index?
What do you understand by a cartesian join?
) How can you count the total no .of records in the specified partition in the Multifile?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Mention how can you connect eme to abinitio server?
can we perform checkin and checkout through sandbox?
What does de-partition mean in abinitio?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
In Join component which record will go to unused port and which will go to reject port ?
How can we RUN a graph in UNIX?
What is the best way of creating huge test feeds?
11. What is the use of allocate()?