What is conditional DML and Structured DML?
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 |
How co>operating system integrates with legacy codes?
Describe which system or process elements you would review when trouble-shooting general server slows ?
Explain the methods to improve performance of a graph?
what is extension list in abinitio?
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 ?
What are the types of data processing you are familiar with?
Explain what is sandbox?
Describe how you would monitor and control database physical file size and growth?
Code check-in and check-out commands in AbInitio
Mention how can you connect eme to abinitio server?
what is hash file in abinitio? how will it read in abinitio? in hash file the data files r combine (file1.dat,file2.dat,file3.dat......etc) how will it divide?
Why do you think data processing is important?