while loading to target Abnormal termination of stage
Posted: Tue Aug 24, 2004 2:16 am
Hi,
I am loading (172000 records) data from sequential file to oracle 9i database. At the end of job I am getting the below error.
“Abnormal termination of stage Dim_Customer_FMT_PCARD_TRANS_Update_2..Transformer_58 detected”
The source and target files columns with data type I am listing below.
S.No columname Sequential file transformer_58 Oracle 9i
1) cust_surr_key @inrownum decimal(6)
2) card_num varchar(19) varchar(19) varchar2(19)
3) cust_name varchar(40) varchar(40) varchar2(40)
4) Busin_type varchar(40) varchar(40) varchar2(40)
5) category varchar(18) varchar(18) varchar2(18)
6) territory varchar(40) varchar(40) varchar2(40)
7) salesman varchar(11) varchar(11) varchar2(11)
balance decimal(8,2) decimal(8,2) decimal(8,2)
9) update_date timestamp timestamp timestamp
10) last_updt_user @logname varchar2(20)
Even though it was aborted, I am able to see data in the target.
Just I am loading like direct mapping. Please can any one able to help me in detail.
Thanks
Regi
I am loading (172000 records) data from sequential file to oracle 9i database. At the end of job I am getting the below error.
“Abnormal termination of stage Dim_Customer_FMT_PCARD_TRANS_Update_2..Transformer_58 detected”
The source and target files columns with data type I am listing below.
S.No columname Sequential file transformer_58 Oracle 9i
1) cust_surr_key @inrownum decimal(6)
2) card_num varchar(19) varchar(19) varchar2(19)
3) cust_name varchar(40) varchar(40) varchar2(40)
4) Busin_type varchar(40) varchar(40) varchar2(40)
5) category varchar(18) varchar(18) varchar2(18)
6) territory varchar(40) varchar(40) varchar2(40)
7) salesman varchar(11) varchar(11) varchar2(11)
![Cool 8)](./images/smilies/icon_cool.gif)
9) update_date timestamp timestamp timestamp
10) last_updt_user @logname varchar2(20)
Even though it was aborted, I am able to see data in the target.
Just I am loading like direct mapping. Please can any one able to help me in detail.
Thanks
Regi