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 are the components new in 2.14 compared to 1.8 and State the usage of the components?
What are the different types of parallelism in ab initio?
How data is processed and what are the fundamentals of this approach?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
explain checkin and checkout?
What are the differences between informatica and abinitio?
How to create repository in abinitio for stand alone system(local nt)?
Explain how abinitio eme is segregated?
What is a rollup component? Explain about it.
What are the different forms of output that can be obtained after processing of data?
What is the architecture of abinitio?
What do you mean by the term data warehousing? Is it different from data mining?
What is the purpose of having stored procedures in a data-based?
Difference between informatica vs ab initio?
Mention how can you connect eme to abinitio server?