Domain to domain communication (rules)

• • Type 2 : If the source Dimension is type 2 then pull the source tables using responsible Talend accounts ,and do the look up on talend and end result should put it on the destination table for example: if DIM plant is in structure domain and it needs keys from finance domain then talend should use finance service account to get data from finance and then do lookup on the talend side and using structure domain service account it should write it on the destination table . if talend dont find the source key, then << add text >>
  • For Type 1 :  generate the key on FACT or DIM table on destination table instead of performing the lookups