Answer / madhugreddy

Strucrured DML is nothing but the normal DML you specify.
Conditional Dml is the one where you write DML based on conditions with IF,IF-ELSE based on the requirement.
most of the times you write structured DML.

Answer / keerthika

Structure DML is usually used to read data file that contains records in each with same data format.

Conditional DML using data file will contain cluster of records in each row with different data format, each record can be read using different conditional DML based on the record identifier at the start of each record row

Structure DML Sample :
record
string(5) name;
decimal(10) contact_number;
end;


Conditional DML Sample :

if(record_identifier=='H') then
record
string(5) file_name;
end;
else if(record_identifier=='D') then
record
string(5) name;
decimal(10) contact_number;
end;
else if(record_identifier=='T') then
record
decimal(10) record_count_in_file;
end;

What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 Answers  

---

Difference between output_index and output_indexes in reformat

0 Answers  

---

What will be the skew for, input file->partition by key-> partition by round robin->output file

0 Answers  

---

11. What is the use of allocate()?

1 Answers   TCL,

---

State the working process of decimal_strip function?

0 Answers  

---

How might you quantitatively measure an improvement made to a query?

2 Answers  

---

Order of Evaluation of Parameters

2 Answers  

---

what is the output when -1 is put in select_expr of FBE?

0 Answers  

---

What is difference between force_error & force_abort? How to use in abinitio graph?

2 Answers   IBM, TCL,

---

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

0 Answers  

---

Can you explain the co>operating system’s processing model?

0 Answers  

---

What are the benefits of data processing according to you?

0 Answers  

---