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

What do you mean by the term data warehousing?

0 Answers  


. What is flow buffering ? How it reduces the chances of having deadlock ?

1 Answers   HCL,


How many parallelisms are in Abinitio?

3 Answers  


To which project that prefix will set is to private project or public project or both?how and where to set?

0 Answers  


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

1 Answers  


What is the function you would use to transfer a string into a decimal?

0 Answers  


What is use of creating a save files? How to use in abinitio graph?

1 Answers   Cognizant, IBM, Intellego, TCL,


What is publickey and private key?what is the use of this two keys?

0 Answers  


How you can test a dbc file ?

1 Answers   TCL,


Have you used the rollup component? Describe how?

0 Answers  


What do you mean by continuous graph? what is it significance?

1 Answers   IBM,


Difference between output_index and output_indexes in reformat

0 Answers  


Categories