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;

List the various vector functions used in ab initio with syntax.

1 Answers  

---

Do you know what a local lookup is?

0 Answers  

---

Explain what is the architecture of abinitio?

0 Answers  

---

How does the bre work with the co>operating system?

0 Answers  

---

What is publickey and private key?what is the use of this two keys?

0 Answers  

---

What metadata importer can do in ab initio?

0 Answers  

---

How to move data from developement to testing and testing to production?

1 Answers   BitWise, CTS, Satyam, Wipro,

---

What are the Graph parameter?

0 Answers  

---

Explain PDL with an example?

0 Answers  

---

What is dependent parameter ?

1 Answers   HCL,

---

What is air_project_parameters and air_sandbox_overrides? what is the relation between them?

1 Answers   IBM,

---

Why might the optimizer use a table scan when an index is available?

0 Answers  

---