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

Answer Posted / ramesh

any number of columns we can perform aggregation
ex:group by deptno,group by deptname,

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different type of jobs in datastage?

602


Explain the importance of surrogate key in data warehousing?

706


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...

1076


How many types of stage?

673


What are the important features of datastage?

616






if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1755


What are the types of containers in datastage?

703


What is difference between join, merge and lookup stage?

634


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1801


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3499


Differentiate between validated and Compiled in the Datastage?

639


which r the connectors used in san?

1786


Triggers,VIEW,Procedures

796


Is possible to create skid in dim,fact tables?

2187


What are the job parameters?

703