Search code examples
mappingetlinformaticainformatica-powercenter

please provide me with a mapping and proper trasnformation in detail

Source 

Id,name
1,Andrew
2,john
3,Robert

Target

detail
((1/Andrew)(2/john)(3/Robert))

please provide solution for the above scenario. Thanks in advance.

Solution

  • In expression transformation, you can do as following:

    ID (I) - ID

    Name (I) - Name

    v_EXP (V) - v_EXP||'('||ID||'/'||Name||')'

    o_EXP (O) - v_EXP

    Then link this exp transformation to aggregator transformation which will assign '(1/Andrew)(2/john)(3/Robert)' to o_EXP. Then push it through exp transformation again and do the following:

    o_EXP (O) - '(' ||o_EXP || ')'