Answer Posted / aditya kundu

The simplest way to remove header and trailer records is to
use a dedup sorted component using a NULL key. This would
treat the entire record set as a single group. Then use
keep_first and keep_last mode of dedup sorted to select the
header and trailer records.

Another way to accomplish similar result set is using a
ROLLUP component on NULL key. Use the first and last
functions in rollup to select the header and trailer
records.

How do you add default rules in transformer?

1263

---

explain the environment varaibles with example?

1138

---

Can anyone give me an exaple of realtime start script in the graph?

1112

---

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

1219

---

What are the different types of partition components in abinitio?

1416

---

What is local and formal parameter?

1450

---

What do you mean by the term data warehousing?

1122

---

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1196

---

Explain what does dependency analysis mean in abinitio?

1205

---

What is rollup component?

1310

---

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

4036

---

How can you export a component’s internal parameters ?

2445

---

What exactly do you understand with the term data processing and businesses can trust this approach?

1157

---

How scientific data processing is different from commercial data processing?

1135

---

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2677

---