How to Load Satellite Table (data vault 2.0)

[Anonymous]

Hi,

I am trying to build a Data Vault 2.0.

I try to load a satellite table, first of all I read from my staging_table, identify new records and load into hub_table and satellite_table, I made this
using a tmap between staging_table and hub_table. In tmap use inner join and reject true.

My problem is when the information in satellite_table that had the same hash key in staging_table, but with different values in the rest of fields.

How can I compare fields of both tables, I would like to do similar as this:

if staging_table.name<>datavault_table.name
then row_with_changes=1
else row_with_changes=0
end

if row_with_changes=1 and with ok I can upload in datavault_table the fiels status as inactive and insert a new record with new values and status as active.

I hope I explain well what I can do.

[Anonymous · Accepted solution]

Hi
Take a look at if/else statement section in this article, it should be helpful.
https://community.talend.com/t5/Design-and-Development/tMap-expression-syntax/ta-p/21575

Regards
Shong

[Anonymous]

Thanks !!!