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 can we RUN a graph in UNIX?
What are the benefits of data analyzing?
Give one reason when you need to consider multiple data processing?
What are the different types of partition components in abinitio?
Where $mpjret is used in ab-initio?
How you can delete an object from EME data store ? How to use in abinitio graph?
what is the relation between EME , GDE and Co-operating system ?
After completion of graph what is the next process to perform? who will perform the later process?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Can you read multiple input files using one input file component ?(same DML)
EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer