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 do we handle if DML changing dynamicaly?

5 Answers   GE, HP, IBM, Mannar Company,


What are the different types of partition components in abinitio?

0 Answers  


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

0 Answers  


What is difference between API

2 Answers   CitiGroup, IBM, TCL,


How to calculate total memory used my a graph?

1 Answers   IBM,


What is the significance of ‘mp run’ command ?

1 Answers   TCL,


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

0 Answers  


State the working process of decimal_strip function?

0 Answers  


. How can you get all the fields form a lookup files ? (Which function)

3 Answers   TCL,


Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

1 Answers  


how to prepare scd2 in abinitio

1 Answers   CTS,


List out the file extensions used in abinitio?

0 Answers  


Categories