What is conditional DML and Structured DML?
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;
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is the difference between sandbox and EME?
What is the function you would use to transfer a string into a decimal?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What is the ab initio business rules environment (bre)?
What is a local lookup?
What a local lookup is?
How can I run the 2 gui merge files?
What are the facts that can compromise data integrity?
What are the primary keys and foreign keys?
How many components in your most complicated graph?
What are the key elements of a data processing system?
Can anyone give me an example of realtime start script in the graph?
Difference between informatica vs ab initio?
In abinitio, what types of parallelism are used?
Mention what is rollup component?