Answer Posted / aditya
is_defined : Tests whether an expression results in a non-
NULL value.
Syn :long is_defined(expr)
is_null :Tests whether an expression results in a NULL
value.
Syntax : long is_null(expr)
is_blank : Tests whether a string contains only blank
characters.
Syntax : long is_blank(string str)
| Is This Answer Correct ? | 29 Yes | 2 No |
Post New Answer View All Answers
List out the file extensions used in abinitio?
Mention what the difference between “look-up” file and “look is up” in abinitio?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
How to add default rules in the transformer?
What is the difference between a scan component and a rollup component?
What is the importance of eme in abinitio?
What is a local lookup?
What do you mean by the overflow errors?
How do you add default rules in the transformer?
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
Why might the optimizer use a table scan when an index is available?
What is a rollup component?
How to add default rules in transformer?
What are the factors on which storage of data depends?
what is the project environment(for each project the environment is same or different to different project)?