what is decoding & what is NVL?

Question Posted / veluruabinitio

what is decoding & what is NVL?..

Answer / gopichinnu

Decoding means It decodes the expression in the way of
If-then-else structure.

NVL means it provides the value for null values.
EX:NVL(comm,0)

Is This Answer Correct ?

3 Yes

2 No

More Ab Initio Interview Questions

Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?

What is AB_LOCAL expression where do you use it in ab- initio?

In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?

How transaction file different from that of a sort file?

What is a deadlock and how it occurs?

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

Explain what is sort component in abinitio?

Can you use scan to generate sequence number ? How to use in abinitio graph?

Do you know what a local lookup is?

What is the use of the co> operating system in ab initio?

What are the differences between informatica and abinitio?

how to calculate EME version using unix ?

For more Ab Initio Interview Questions Click Here