topic Re: Problem with null values that insert in output table in Talend Studio

Problem with null values that insert in output table

Anonymous — Sat, 16 Nov 2024 06:13:13 GMT

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

Re: Problem with null values that insert in output table

Anonymous — Thu, 28 Mar 2019 20:05:06 GMT

Can you look at tMap setting at output end once . or share the screen shot of your tMap along with the setting one at the right side

Re: Problem with null values that insert in output table

Tasfiahm — Thu, 28 Mar 2019 20:24:21 GMT

Please check the join of the columns. If the join is not configured in proper way it may write null in the table. For testing create a separate out put inside tmap. Drag one row from the main table and another from the lookup table. Use a tlog row component or any preferred output.

If possible Please share some screen shot of your designer and tmap

Re: Problem with null values that insert in output table

Anonymous — Fri, 29 Mar 2019 09:37:25 GMT

Hello, here is the screenshot of the job

Here is the tmap :

Row16 is the table with Transactions1

Row11 is the table with Products

You can see on the tmapmvt the last 3 lines which come with null values.

Tanks

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 06:45:59 GMT

Hi,

Could you please mark the column where you are adding the product details from lookup? In first glance, I could not see any mapping done from product lookup table for Product column.

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 🙂

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 11:09:06 GMT

Hello

Here is the screenshot

Tanks

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 11:13:54 GMT

Hi,

Could you please change thefirst part of NULL check as shown below? Then it should detect the NUll value. Please also verify whether null is coming in lookup table or empty string. If it is empty string, it will not be considered as NULL.

Relational.ISNULL(row11.T8_PRIXV3)? 0: row11.T8_PRIXV3

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 🙂

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 13:08:00 GMT

I have one precision to make :

When I do an "Update or Insert" on the Output table, the values are presents.

But when I do an "Insert" on the Output table, the values doesn't appear.

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 13:13:41 GMT

Nikhil, I modified the expression with the expression you suggest me.

I have to wait new data in a couple hours to test it with an Insert in the Output Table.

Tanks

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 13:49:55 GMT

Hi,

Could you please check whether the data's key value is correct. The data could be getting rejected due to key value issues. Could you please run the job after selecting Die on error check box?

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 🙂

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 14:13:03 GMT

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.

Re: Problem with null values that insert in output table

Anonymous — Mon, 01 Apr 2019 21:03:35 GMT

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

Re: Problem with null values that insert in output table

Anonymous — Tue, 02 Apr 2019 07:13:49 GMT

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 🙂

Re: Problem with null values that insert in output table

Anonymous — Wed, 03 Apr 2019 12:17:56 GMT

Hello

Tanks for help.

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

Regards