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
What are the different type of jobs in datastage?
Explain the importance of surrogate key in data warehousing?
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...
How many types of stage?
What are the important features of datastage?
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?
What are the types of containers in datastage?
What is difference between join, merge and lookup stage?
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
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.
Differentiate between validated and Compiled in the Datastage?
which r the connectors used in san?
Triggers,VIEW,Procedures
Is possible to create skid in dim,fact tables?
What are the job parameters?