Submitted Questions

  • 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

  • Reading flat files

    While reading flat files can we increase the default size of 1024 bytes of a line?If yes then is there any upper limit for that?

    Sreenu

    • Nov 18th, 2011

    Yes, we can increase the line sequential buffer length in the session properties.

    There is no hard limit actually, but when the block size and the DTM buffer size also should be increased to be able to process the records