on how many columns we can perform aggregation in the
Aggregator stage?
Answers were Sorted based on User's Feedback
Answer / ramesh
any number of columns we can perform aggregation
ex:group by deptno,group by deptname,
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / devendra singh
any no of columns we can aggregate in aggregation stage
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kiran
Depends upon Requirement....u can apply aggregations
Is This Answer Correct ? | 2 Yes | 3 No |
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
how to convert rows into columns
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
How do you design PX Routines ?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
What is RCP
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
How and where you used hash file?
How many number of reject links merge stage can have?