Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is conditional DML and Structured DML?

Answers were Sorted based on User's Feedback



What is conditional DML and Structured DML?..

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

What is conditional DML and Structured DML?..

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

Post New Answer

More Ab Initio Interview Questions

How can we RUN a graph in UNIX?

3 Answers  


What are the benefits of data analyzing?

0 Answers  


Give one reason when you need to consider multiple data processing?

0 Answers  


What are the different types of partition components in abinitio?

0 Answers  


Where $mpjret is used in ab-initio?

0 Answers  


How you can delete an object from EME data store ? How to use in abinitio graph?

1 Answers   IBM, TCL,


what is the relation between EME , GDE and Co-operating system ?

4 Answers  


After completion of graph what is the next process to perform? who will perform the later process?

1 Answers  


What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

0 Answers   IBM, TCL,


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?

0 Answers   HP,


Can you read multiple input files using one input file component ?(same DML)

4 Answers   IBM,


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

3 Answers   Accenture,


Categories