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 |
What is the diff between abinitiorc and .abinitiorc files ?
What is the significance of record required indicator of Join component ?
Difference between private project parameters ,public project parameters and common project parameters?
What is Is_defined(), Is_null(), Is_Blank()?
How to create project (public,private,common,client) what are the differences between them?
What are the kinds of layouts does ab initio supports?
What information is provided by .dbc file extension for connecting to the database?
What are the different versions and releases of ABinitio ?
How will u remove header record? How will u remove tailer record?
why Skew should always be 0 ? How to use in abinitio graph?
How to connect mainframe to Abinitio?
What is the difference between a scan component and a rollup component?