Awesome. excellent. thank you so much. 3 million records in 5 minutes is really encouraging. yes. this code looks clean and we are on the right track. I noticed that the acc_type and acc_code fields are missing in account XML and txn_code is missing in transaction XML. these fields are coming from different tables too. a account will have an acc_type but multiple acc_codes. if there is no acc_types and acc_codes, we need to have empty tags. a transaction can have multiple txn_code. if there are no txn_codes, we need to have empty tag. here is the DDL and DML for these tables. Also, could you please post the code to process the CSV file? I will go with the DBI connection code.

drop table rltp_mngr;  
drop table product;  
drop table cust;  
drop table account;  
drop table transaction;  
drop table acctype;  
drop table txntype;  
  
create table rltp_mngr(rltp_id number,rltp_name varchar2(50));  
Insert into rltp_mngr values(10, 'Phil');  
Insert into rltp_mngr values(20, 'Jack');  
  
create table product(rltp_id number,prod_id number,prod_name varchar2(
+50));  
Insert into product values(10,1, 'Personal');  
Insert into product values(20,1, 'Business');  
 
create table cust(rltp_id number,prod_id number,cust_id number,cust_na
+me varchar2(50));  
insert into cust values(10,1,2,'Fixed');  
insert into cust values(20,1,2,'Fixed');  
 
Create table account(rltp_id number,prod_id number,cust_id number,acc_
+id number,acc_name varchar2(50),acc_balance number(18,2));  
insert into account values(10,1,2,3,'Savings',3000);  
insert into account values(10,1,2,7,'Savings',3000);  
insert into account values(20,1,2,3,'Savings',3000);  
 
create table transaction(rltp_id number,prod_id number,cust_id number,
+acc_id number,txn_id number,txn_amt number(18,2));  
insert into transaction values(10,1,2,3,4,500);  
insert into transaction values(10,1,2,3,5,500);  
insert into transaction values(10,1,2,3,6,500);  
insert into transaction values(10,1,2,7,8,500);  
insert into transaction values(20,1,2,3,4,500);  
 
create table acctype(rltp_id number,prod_id number,cust_id number,acc_
+id number,acc_type varchar2(5),acc_code varchar2(10));  
insert into acctype values(10,1,2,3,'X','ZZ');  
insert into acctype values(10,1,2,3,'X','YY');  
insert into acctype values(10,1,2,7,'X','AA');  
insert into acctype values(10,1,2,7,'X','BB');  
  
create table txntype(rltp_id number,prod_id number,cust_id number,acc_
+id number,txn_id number,txn_code varchar2(10));  
insert into txntype values(10,1,2,3,4,'11');  
insert into txntype values(10,1,2,3,4,'12');  
insert into txntype values(10,1,2,7,8,'11');  
insert into txntype values(10,1,2,7,8,'12');  
insert into txntype values(10,1,2,7,8,'13');
[download]

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.