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]

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

[Tasfiahm]

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

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

Hello

Here is the screenshot 

Tanks

[Anonymous]

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 🙂

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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 🙂