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
SELECT EMPLOYEE_ID, (CONTRIBUTION / SUM (CONTRIBUTION) OVER (PARTITION BY FAMILY ID) ) * 100 || % AS EXPECTED_VALUE FROM FAMILY;

Mohan Krishna Bellamkonda

• Sep 7th, 2017

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

Answer Question  Select Best Answer

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 19th, 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

Answer Question  Select Best Answer