Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
We have 2 different Oracle Databases/Connections:
We want to import a table from each database, join them together and append the result in an already existing table in the ALPHA connection.
The table from the connection ALPHA has as schema (in the oracle db)
REFERENCE_PERIOD (DATE) | IDENTIFIER (VARCHAR2(10)) | X_FEATURE (VARCHAR2(20))
The table from the connection BETA has as schema (in the oracle db)
REFERENCE_PERIOD (DATE) | IDENTIFIER (VARCHAR2(10)) | Y_FEATURE (VARCHAR2(20))
The output table ALPHA_OUTPUT that's stored in the connection ALPHA has as schema
REFERENCE_PERIOD (DATE) | IDENTIFIER (VARCHAR2(10)) | X_FEATURE (VARCHAR2(20)) | Y_FEATURE (VARCHAR2(20))
To achieve that we create a visual recipe* as follows:
Running this we are getting the following error:
"Table already exists but with an incompatible schema: in act.compute_ALPHA_OUTPUT: Type mismatch for column 1 (REFERENCE_PERIOD) : 'TIMESTAMPLTZ' in dataset, 'TIMESTAMP'(93:DATE) in table"
Things I have already tried:
Any suggestions?
* Visual recipe: It's the only option that "works" with multiple connections. "SQL Query recipe" and "SQL Script recipe" both throw an error that multiple connections are not supported.