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 |
What is a merge?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to design the change capture stage in(data stage parallel jobs) type 2
what is initial load and incremental load
What is the sortmerge collector?
What are the various kinds of the hash file?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
DataStage Scenario based Interview Questions
how can we create rank using datastage?what is the meaning of rank?
How to lode data in sequntional files perform faster?
How do you import and export the datastage jobs?