Is it possible to do a SQL mapping in a data load rule based on period being loaded to?
Summary:
I am trying to determine if it is possible to do a SQL mapping in a data load rule based on the period being loaded to.
Content (please ensure you mask any confidential information):
In general I know that you can do a SQL mapping dependant on the value in another dimension but cannot figure out how to do this based on period being loaded to.
As an example, we have mappings like this for the dimension assigned to UD2:
CASE
WHEN ACCOUNTX LIKE '1.1.1.111'THEN 'No Program'ELSE UD2END
I would like to do something like this using Period and Year but since these aren't dimensions in Data Integrator like ACCOUNT or UD2, I can't figure out how to reference them.
Tagged:
0