hello,
tell me the function which removes spaces from decimal
field?
Answer Posted / prakash b
Use 'decimal_lpad' or 'decimal_strip'
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
Describe the evaluation of parameters order in ab initio?
Have you used rollup component? Describe how.
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
How co> operating system natively processes the data?
What is a local lookup?
How would you find out whether a sql query is using the indices you expect?
What is the difference between a scan component and a rollup component?
What is the function you would use to transfer a string into a decimal?
You can ask about different vector functions. How to use in abinitio graph?
What exactly do you know about the typical data analysis?
How is the partitioning with key different from round robin partition?
Have you used the rollup component? Describe how?
What is brodcasting and replicate?
Mention what is rollup component?