I have to pull data using VIEW on Oracle and insert them into one table on Oracle.
Even though the source connector for the View in Data Stage can show Data by [View Data] option, ETL job fails when I run it.
Target connector also responds when I click [View Data] option on the target side. However, it almost always fails to run the ETL job itself.
The connector connected to Oracle server, but it does not process rest of the ETL work.
I could populate the target table only once through the simple job flow, consisting of two Oracle connectors.
The version of connectors is 11g. I also tried 12c. Both versions show the same symptoms. Does anyone have an idea to solve this issue?
I checked out sessions along with SID, Serial # and Active Status on Oracle. It creates 9 sessions for the one ETL jobs. I'm not sure whether it's normal or not.
It should generate INSERT statement, but it started to generate INSERT statement when I stopped the ETL job by Data Stage Director.
Which connector (source or target) throws an error and what is the exact error message?
The initial post says: "The version of connectors is 11g. I also tried 12c. Both versions show the same symptoms." The version you select in the Oracle Connector should match the version of Oracle Client you are using. When you use Oracle Client 12c, 18c, 19c, or 21c, choose 12c in the Connector stage editor on BOTH connectors.
The initial post says: "I checked out sessions along with SID, Serial # and Active Status on Oracle. It creates 9 sessions for the one ETL jobs." There will be 1 session for the DataStage Conductor and one session for each player (i.e., compute node)). So, if you have 2 Oracle Connectors in your job and 4 players, that will be 10 sessions. You can reduce the number of sessions in multiple ways. For example,
I hope this helps.