Answer Posted / subramanian

you can achieve the result using Normalize Component.

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

954

---

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

1173

---

What is the ab initio business rules environment (bre)?

1163

---

What do you mean by a transaction file and how it is different from that of a sort file?

1036

---

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?

997

---

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1728

---

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

1064

---

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

2005

---

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1105

---

How transaction file different from that of a sort file?

1398

---

What is abinitio?

1163

---

What is a partition and what are the different types of partition components in abinitio?

1264

---

You can ask about different vector functions. How to use in abinitio graph?

5529

---

Can you explain data flow graph with an example?

1214

---

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

1357

---