Answered Questions

  • SCD Transformation

    Can we use both SCD Type1 and Type2 transformations in one mapping? If yes how?

  • Unconnected lookup

    Supose we have 4 column based on same condition can we use unconnected lookup in that case?

    Yoganand

    • Aug 9th, 2011

    Hi,

    We can pull any number of columns in unconnected lookup nut with the help of Lookup override. We can concatenate many columns and then use an expression to deconcat those values.


    Thanks,
    Yoganand

  • Typical Scenario - Schedule

    Please help to set up following scenarioI have a source either file or db tableEno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2Want to run a session 3 times.First time: it should populate dept 1Second time: dept 2 onlyThird time: dept 3 onlyHow can we do this?

    MAHESH MANAM

    • Sep 27th, 2012

    We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...

  • Duplicate Records

    If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?

    Anil

    • Jun 22nd, 2016

    We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!

    Anupam Kumar

    • Apr 8th, 2016

    Use Router. Create two group and just put TRUE in both

  • Scenario based

    If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...

    Mohan Krishna Bellamkonda

    • Sep 7th, 2017

    Code
    1. SELECT EMPLOYEE_ID, (CONTRIBUTION / SUM (CONTRIBUTION) OVER (PARTITION BY FAMILY ID) ) * 100 || % AS EXPECTED_VALUE FROM FAMILY;

    Mohan Krishna Bellamkonda

    • Sep 7th, 2017

    Code
    1. SELECT B.ID,(B.CONTRIBUTION/A.CONTRIB)*100||% AS EXPECTED VALUE FROM
    2. (SELECT FAMILY_ID,SUM(CONTRIBUTION) FROM FAMILY
    3. GROUP BY FAMILY_ID) A, FAMILY B
    4. WHERE A.FAMILY_ID=B.FAMILY_ID