Answer Posted / harika motepalli

Both Output index & output indexes used for "Conditional assignment" of your input data to out ports but the only difference is Output_index allows to assign to only 1 output port whereas Output_indexes allows to assign to multiple output ports.

********************************* Eg 1 **********************************

out::output_index(in)=

begin

out:1:if ( in.country=='Malaysia') 0 ; // if country name is Malaysia then divert input records to out0 port

out:2: if (in.country--'Singapore') 1;

out:: 2;

end;

**************************** Eg 2 **********************

out::output_indexes(in)=

begin

out:1:if ( in.country=='Malaysia') [ vector 0,1] ; // if country name is Malaysia then divert input records to out0 & out1 ports

out:2: if (in.country--'Singapore') [ vector 2 ];

out:: [vector 3 ];

end;

Explain the difference between the truncate and delete commands?

1203

---

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

1740

---

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1089

---

Explain what is de-partition in abinitio?

1401

---

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

1476

---

What do you understand by overflow errors?

1296

---

How can a graph be run infinitely?

1171

---

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

1093

---

List out the file extensions used in abinitio?

1126

---

What is de-partition in abinitio?

1414

---

What do you mean by a transaction file?

1300

---

How do you add default rules in transformer?

1262

---

What is rollup component?

1309

---

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

1111

---

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1194

---