Answer Posted / shukur

i think two files are same then there is no need to create new version number....so we have to check two files and create version numbers to those...

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

1030

---

In abinitio, what types of parallelism are used?

1125

---

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

1126

---

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4032

---

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?

1030

---

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1051

---

What are the reasons for which business can trust the approach of data processing?

1236

---

Mention some file extensions which are used in abinitio?

1175

---

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

1053

---

What is the difference between a scan component and a rollup component?

1224

---

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

1400

---

can we perform checkin and checkout through sandbox?

1220

---

Explain how you can run a graph infinitely in ab initio?

1161

---

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

1181

---

Mention what is rollup component?

1178

---