Real Scenario 4: ORA-12899 Inserted value too large for Coulmn.

Real Scenario 4: ORA-12899 Inserted value too large for Coulmn.

Solutions:

We can solve this issue in the below ways:(Informatica)

****Temporary fix***************

we can allow the number of rejects by using STOP ON ERRORS Property in Session properties to recject the records.

so that all the records whcih are rejecting will be skipped and job will be completed succesfully.

******Permenant fix*************

1->we have to identify the number of records which are rejected.

2-> we need to check the length of the field (NAME_USER) in the rejected records. it shpould be greater then the column defined value.

      Ex: if Column USER_NAME is defined as below
                    
                      USER_NAME VARCHAR2(10);

     But the Value of USER_NAME in the rejected records are greater than 10.due to this the records are rejected while Loading into table EXAMPLE.

     we can check the length of USER_NAME for all rejected record as below.

     if Suppose we are Sourcing the Data from SOURCE_EXAMPLE table and Loading it into EXAMPLE Table.
      
     select LENGTH(USER_NAME),USER_ID from XYZ.SOURCE_EXAMPLE where LENGTH(USER_NAME)>10;
    
     This above Query will give all the record which are Having length >10.

3-> we need to Correct the field Size to allow the Records into the table EXAMPLE. if the data is valid.

4-> if the data in the field USER_NAME is not valid then we need to correct the Data iin the Source end. then please run the Failed job.

Thanks,
Anilkumar