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 |
State the difference between an operational datastage and a data warehouse?
what is the definitions for Datawarehose and Datamart?
client know skid info?
How can you find out whether datastage process is running or not in unix?
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
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?
how to configure databases through datastage
Explain briefly scd type2 in datastage7.5x2(parallel)
What is the difference between validated and compiled in the datastage?
What is the process of killing a job in datastage?
Why do you need stage variables?
difference between function and procedure...