on how many columns we can perform aggregation in the Aggregator stage?

on how many columns we can perform aggregation in the
Aggregator stage?

Question Posted / vijayp.dw

3 Answers
11285 Views
Reliance, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

on how many columns we can perform aggregation in the Aggregator stage?..

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

on how many columns we can perform aggregation in the Aggregator stage?..

Answer / devendra singh

any no of columns we can aggregate in aggregation stage

Is This Answer Correct ?

6 Yes

0 No

on how many columns we can perform aggregation in the Aggregator stage?..

Answer / kiran

Depends upon Requirement....u can apply aggregations

Is This Answer Correct ?

2 Yes

3 No

Post New Answer

More Data Stage Interview Questions

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

Explain the scenarios where sequential file stage runs in parallel?

3 Answers Accenture,

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers Alpharithm Technologies,

wt is the difference between swith and filter stage

6 Answers IBM,

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers Cap Gemini, IBM,

What is the use of Row generator stage?

2 Answers

What are stage variables and constants?

0 Answers

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers Bank Of America, IBM,

what is the main differences between Lookup, Join and Merge stages?

9 Answers HCL,

What are operators in datastage?

1 Answers

What are the different options associated with dsjob command?

0 Answers

what is normalization and denormalization

2 Answers CTS,

For more Data Stage Interview Questions Click Here