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)

What do you mean by data sorting?

1204

---

What a local lookup is?

1042

---

What is the role of co-operating system in abinitio?

1446

---

What is de-partition in abinitio?

1363

---

What metadata importer can do in ab initio?

1221

---

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

1149

---

How can we increase the loading performance of oracle table in AbInitio?

1146

---

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

2230

---

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

1219

---

What information does a .dbc file extension provides to connect to the database?

1232

---

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1079

---

In abinitio, what types of parallelism are used?

1091

---

Explain how abinitio eme is segregated?

1496

---

What is the purpose of having stored procedures in a database?

1147

---

How is the partitioning with key different from round robin partition?

1218

---