Redirect target value in one dimension as a source value in another dimension in DM
Summary:
Content (please ensure you mask any confidential information):
Hi Everyone,
Using Data management, we are retrieving the member description through SQL mapping. Eg: P001_LE01_CC01. Additionally I have mentioned the SQL code below.
(SELECT DISTINCT DESCRIPTION
FROM AIF_TARGET_APPL_MEMBERS
WHERE DIMENSION_ID=(SELECT DIMENSION_ID
FROM AIF_TARGET_APPL_DIMENSIONS
WHERE APPLICATION_ID=(SELECT APPLICATION_ID
FROM AIF_TARGET_APPLICATIONS
WHERE APPLICATION_NAME='Vision')
AND TARGET_DIMENSION_NAME='Category')
AND MEMBER_NAME=UD4 )
Member description: P001_LE01_CC01
Then we have a requirement to split that member description based on the delimiter "_" into a few other columns using the "Split" mapping expression available in data integration. To achieve this, it seems we need to redirect the target value "description" as a source value for other dimensions. How we can achieve this? Do we have another way to accomplish this task? Appreciate your answers on this.