State the first_defined function with an example?

Answer Posted / hamshapriya

This function is similar to the function NVL() in Oracle database

- It performs the first values which are not null among other values available in the function and assigns to the variable

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to insert/update a csv file by comparing it with another csv file?

1877


Mention what is the syntax for m_dump in abinitio?

1058


What are the features of ab initio?

727


What are the facts that can compromise data integrity?

743


explain checkin and checkout?

755






How can I run the 2 gui merge files?

797


what is the difference between i)public ii)private iii)common and client projects?

1805


What are the functions of the replicate and dedup component?

712


What is air-project parameter ?

1857


what is the output when -1 is put in select_expr of FBE?

1059


What will be the skew for, input file->partition by key-> partition by round robin->output file

500


What is the function you would use to transfer a string into a decimal?

831


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

1817


what is the project environment(for each project the environment is same or different to different project)?

1762


What is the max core of a component?

694