Answer Posted / 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 is the purpose of having stored procedures in a data-based?

760

---

What is a deadlock and how it occurs?

870

---

How can you import XML repositories exported from different tools like ODI

3319

---

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

775

---

Describe the grant/revoke ddl facility and how it is implemented?

899

---

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

1813

---

Explain how you can run a graph infinitely in ab initio?

857

---

What information is provided by .dbc file extension for connecting to the database?

893

---

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

868

---

How many components in your most complicated graph?

935

---

What exactly do you know about the typical data analysis?

795

---

explain the environment varaibles with example?

817

---

To which project that prefix will set is to private project or public project or both?how and where to set?

1603

---

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

774

---

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

2591

---