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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between sandbox and EME?

1206


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

1150


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2768


What is the ab initio business rules environment (bre)?

1109


What is a local lookup?

1176


What a local lookup is?

994


How can I run the 2 gui merge files?

1118


What are the facts that can compromise data integrity?

1085


What are the primary keys and foreign keys?

1040


How many components in your most complicated graph?

1228


What are the key elements of a data processing system?

1139


Can anyone give me an example of realtime start script in the graph?

1105


Difference between informatica vs ab initio?

1247


In abinitio, what types of parallelism are used?

1024


Mention what is rollup component?

1062