external tables LKM: wrong column order?
458846Mar 15 2010 — edited Mar 16 2010I'm experiencing some unexpected behavior with an Oracle external table LKM.
The C$ table (external) that gets created has the columns in the wrong order. I know they are correct in the Model. Because the external table isn't defined right, the IKM won't load anything.
Here's the start of the create table script:
create table ETL_USER.C$_0SCSW_SOM_NBME
(
C1_SCHOOL_ID VARCHAR2(6),
C2_TEST_DATE VARCHAR2(10),
C3_SCORE NUMBER(4),
C7_ORDER_NUMBER VARCHAR2(8),
C6_EXAM VARCHAR2(50),
C5_ID VARCHAR2(9),
C4_EXAMINEE VARCHAR2(50)
)
You can even see from C#_ that the fields are in the wrong order.
What's up with that? :-)
John