Problem with null values that insert in output table

[Anonymous]

Hello

I work with Oracle Database.

I have a problem with null values that insert in output table instead of data after a tmap component.

I have 2 tables in input :

- Transactions1 (the list of sales)

- Products (the list of product)

I have 1 table in output :

- Transactions2 (the list of sales witch an information of product price)

I have a tmap with a left outer join on productID between table Transactions1 and table Products

The table Transactions1 is linked to table Transactions 2 on TransactionID.

Each day, I insert new record from table Transactions1 in the table transactions2 with a column « product price » (the information should come from table Products)

The problem is that the column « product price » in output table Transactions2 is null in all records.

Could you help me to find out what is wrong in the configuration ?

Tanks

[Anonymous]

When I setup "insert" on Output Component, I get the error : java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SID.TF_MVT_STOCK_PK) violated

I have to select "Update or Insert" to make it work without errors. 

When I choose "Update or insert", old data get updated with my table Product. But new data comes with null value.

[Anonymous]

So, I have new data tonight.

On the first run with "update or insert". The job updated the old lines, but the new lines came with null value.

On the second run of the job, it updated the value

so the job always match the 2 linked table with an update, but never with an insert.

Tanks for help

[Anonymous]

Hi,

    Could you please add a tLogrow just before tOracleOutput to see the records getting loaded to Oracle DB? Also please check which column are you using as key values to insert or update records. 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous · Accepted solution]

Hello

Tanks for help.

I created the job from scratch and now it's working.

Regards