Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Why my data is not been written in the oracle database? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why my data is not been written in the oracle database?

Received Response
11
Views
1
Comments

Summary:

Hi, I'm green in OCI Data Integration. Some doubts here regarding "Target Operator". Let me try to explain: I'm doing a flow using 2 sources from ADW (Source A and Source B). Nice and clean! Just one data type transformation and a Lookup to relate both sources and then append data from source B into source A. My job is to get the data, related both and then write all the columns it in the schema/table.

The case is: in the last step until Target operator (lookup), I am able to see the data in the panel, from source A and B related. In the Target operator I choose to write the flow as "Insert > Create a new entity" in the ADW schema test and table my_first_test. When the task ends and I select * from the table there is nothing from the source B in the table, just from the source A!!! What I am doing wrong in this case? May I create another step after lookup, like a new expression to to something?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!