Here i am explaining with example data file and example of dml file in ab initio
data will be like this
102,Damodar Reddy,M,Madanapalle,90000,
103,Prasad Kumar,M,Anantapur,50000,
104,Jim Tpt,M,Tirupati,40000,
105,Chandra Mouli,M,Bangalore,100000,
106,Mohan Narayana,M,Vizag,90000,
107,Mahesh Reddy,M,Kadapa,34000,
108,Jyothi Kumari,F,Hyderabad,40000,
dml expression like this in ab initio
record
decimal (",") emp_id;
string (",") first_name;
string (",") last_name;
string ( ",") gender;
string (",") place;
decimal (",\r\n") salary;
end;
if you have any queries please comment below i can respond as early as possible.above i explained in detail example data with sample dml ab initio.
data will be like this
102,Damodar Reddy,M,Madanapalle,90000,
103,Prasad Kumar,M,Anantapur,50000,
104,Jim Tpt,M,Tirupati,40000,
105,Chandra Mouli,M,Bangalore,100000,
106,Mohan Narayana,M,Vizag,90000,
107,Mahesh Reddy,M,Kadapa,34000,
108,Jyothi Kumari,F,Hyderabad,40000,
dml expression like this in ab initio
record
decimal (",") emp_id;
string (",") first_name;
string (",") last_name;
string ( ",") gender;
string (",") place;
decimal (",\r\n") salary;
end;
if you have any queries please comment below i can respond as early as possible.above i explained in detail example data with sample dml ab initio.