Answer Posted / sreedevi

In API mode, the insertion of data into database follows all the constraints of database. The API mode will interact with the database on a per-record basis. This means that every record is handled by the database But in Utility mode, that disables the constraints & inserts the data into database.

What is the architecture of abinitio?

1149

---

What are the co> operating system’s assorted library of integrated components?

1162

---

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

1406

---

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?

1032

---

What is broadcasting and replicate?

1219

---

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1479

---

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1741

---

What do you mean by the term data warehousing?

1122

---

What parallelisms does Abinitio support?

1258

---

Why might the optimizer use a table scan when an index is available?

2352

---

Where $mpjret is used in ab-initio?

1190

---

How would you find out whether a sql query is using the indices you expect?

1113

---

What are differences between different versions of co-op?

1270

---

What information is provided by .dbc file extension for connecting to the database?

1220

---

How can you force the optimizer to use a particular index?

1126

---