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 |
how to find no.of records in sequntial file itself?
What are the repository tables in datastage?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what is the main differences between Lookup, Join and Merge stages?
Can we use Round Robin for aggregator?is there any benefit underlying?
types of errors in datastage?
can explain wt is the pool for file.
What are the types of views in datastage director?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?