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 difference between partitioning with key / hash and round robin?

1472

---

Have you ever encountered an error called “depth not equal”?

1218

---

Why is data processing considered beneficial?

1122

---

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

1163

---

What is the architecture of abinitio?

1149

---

Explain the ab initio etl tool in high level?

1205

---

explain the environment varaibles with example?

1138

---

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

1220

---

How can a graph be run infinitely?

1171

---

Explain how abinitio eme is segregated?

1563

---

How to compare two dmls in abinitio

1878

---

Describe what the SQL Server tempdb and tlog files are used for?

2389

---

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1393

---

What do you understand by local lookup?

1213

---

Have you worked with packages?

1269

---