Load partial data from one db table to anothe

CloverDX Platform
1

I try to load 2 columns from source table to 2 columns in target table. Even if I specified load fields, clover fields, I always get the following error message.

ERROR [DB_OUTPUT_TABLE0] - java.sql.SQLException: Maximum # of errors exceeded when inserting record: ORA-01401: inserted value too large for column

The 2 columns in source table have either same or bigger size than the 2 columns in target table.

SQL> desc LOAD_GLXY_DEMOG_UNIV
Name Null? Type
----------------------------------------- -------- -----------------
MEASUREMENT_PERIODS VARCHAR2(50)
COVERAGE_AREAS VARCHAR2(50)
UE NUMBER(10)
INTAB NUMBER(10)
SECTION VARCHAR2(10)

SQL> desc LOAD_GLXY_DEMOG
Name Null? Type
----------------------------------------- -------- -----------------
SECTION VARCHAR2(10)
ORIGNATORS VARCHAR2(4)
TELECAST VARCHAR2(80)
DAYS VARCHAR2(80)
S_TIME VARCHAR2(80)
R_DUR VARCHAR2(80)
MEASUREMENT_PERIODS VARCHAR2(40)
…

Only one row from source table LOAD_GLXY_DEMOG has been inserted into the target table, LOAD_GLXY_DEMOG_UNIV

Here is my graph.

<?xml version="1.0" encoding="UTF-8"?>

Please help!

Wendy

2

Correct the typo in my original message:

The 2 columns in source table (LOAD_GLXY_DEMOG) have either same or smaller size than the 2 columns in target table(LOAD_GLXY_DEMOG_UNIV).