What is conditional DML and Structured DML?

Answers were Sorted based on User's Feedback



What is conditional DML and Structured DML?..

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.

Is This Answer Correct ?    16 Yes 0 No

What is conditional DML and 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;

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

In abinitio, what types of parallelism are used?

0 Answers  


If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.

2 Answers  


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

0 Answers  


What parallelisms does Abinitio support?

0 Answers  


Why do you think data processing is important?

0 Answers  


Have you eveer encountered an error called "depth not equal"?

2 Answers  


How can you view the data in the Multifile

4 Answers   IBM,


What do you mean by continuous graph? what is it significance?

1 Answers   IBM,


How will you use EME for view or publish metadata reports using EME?

1 Answers  


why Skew should always be 0 ? How to use in abinitio graph?

1 Answers   IBM, TCL,


Name the different type of processing based on the steps that you know about?

0 Answers  


Explain the ab initio etl tool in high level?

0 Answers  


Categories