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

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

State the difference between an operational datastage and a data warehouse?

0 Answers  


what is the definitions for Datawarehose and Datamart?

4 Answers  


client know skid info?

0 Answers   NTT Data,


How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,


Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  






i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,


how to configure databases through datastage

2 Answers  


Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,


What is the difference between validated and compiled in the datastage?

0 Answers  


What is the process of killing a job in datastage?

0 Answers  


Why do you need stage variables?

0 Answers  


difference between function and procedure...

1 Answers   IBM,


Categories