topic Insert and Update rows in Fact table of data warehouse in Talend Studio

Insert and Update rows in Fact table of data warehouse

Anonymous — Sat, 16 Nov 2024 05:12:02 GMT

Hi,

I am facing an issue while performing insert or update operation in Fact table. My scenario is : I have selected 3 columns in update key and one of the column from the 3 is null , I need to update the value which contains null with the next value of that id and that column is in update key.

I want to perform one to many relationship using tmssqloutput component for both insert and update, for that I have set Action on data to insert or update. I have set update key in Advanced Settings( Use field options).

Thanks,

Dhara

Re: Insert and Update rows in Fact table of data warehouse

Anonymous — Tue, 23 Jul 2019 21:36:56 GMT

Hi,

Since you are trying to match the keys with null, the records will not match. The reason is that DB will not consider one null as equal to another null. So you will have to use other columns which can uniquely identify the record and perform the match based on those columns.

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 🙂