State the first_defined function with an example?

Question Posted / deepak kumar

1 Answers
7849 Views
I also Faced
E-Mail Answers

State the first_defined function with an example?..

Answer / 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

More Ab Initio Interview Questions

Which component breaks the pipe line parallelism in graph?

3 Answers Wells Fargo,

difference betwween check point and phase?

2 Answers IBM,

How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?

1 Answers

Can you read multiple input files using one input file component ?(same DML)

4 Answers IBM,

) Layout? What is the Dataset & Program Component Layout

2 Answers TCL,

Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?

3 Answers IBM, TCL,

i have input like this TABA 1 TABA 2 TABA 3 TABA 4 TABB 7 TABB 8 TABC 1 TABC 2 TABC 5 OUT PUT NAME COL1 COL2 COL3 COL4 TABA 1 2 3 4 TABB 7 8 TABC 1 2 5

0 Answers

What do you mean by the term data warehousing? Is it different from data mining?

0 Answers

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

0 Answers CTS,

what is SSH?What is the differences between the SSH,SSH1,SSH2?

2 Answers

Describe the grant/revoke ddl facility and how it is implemented?

0 Answers

How to migrate the code FROM development to QA and QA to production?

1 Answers CTS,

For more Ab Initio Interview Questions Click Here