DSXchange

I am using below schema file and source file.one to one mapping between source and target.

Job was aborted with below error:

The connector could not create table SAMP_EMP because the data type information for the column No could not be obtained.

samp_emp.txt
1,a
2,b
3,c

temp.osh
record
(
No:string[];
Name:string[];
)


sequentialfile-->transformer-->oracle connector

Carefully read the error message again... it's not a RCP error, per se.

That sounds like a defect to me. I can not think of any reason why the Oracle Connector can not interpret No as string[]. Maybe it's a limitation for the Oracle Connector in creating a table?

Does it work when you are inserting into an existing table?

-T.J.

Sounded more like 'I accidentally checked the Create Table option' to me... and yes, you would need a value for column's precision for Oracle to be able to create the table. If that's really what they wanted.