Select Account from Target Dimension in Data Mapping
We have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwise all source members should be mapped to default account.
I am trying below option where I need help.
Source (*) → Target (#SQL)
SQL- Case when Account in (Select ACCOUNTX from V_DIM) then Account
ELSE 'Default'
END
Tagged:
0