Interested to Buy Any Domain ? << Click Here >> for more details...
What is conditional DML and Structured DML?
- 2 Answers
- 28106 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Mention some file extensions which are used in abinitio?
What is common among data validity and data integrity?
what is deeup in unique only?
What exactly do you understand with the term data processing and businesses can trust this approach?
What are the benefits of data processing according to you?
How you can run a graph infinitely in ab initio?
Explain batch processing in ab initio?
What is brodcasting and replicate?
Difference between Force_error & Force_abort?
What are the fundamental blocks of co> operating system of ab initio?
How you can test a dbc file ?
Why do you think data processing is important?
Teradata 
