Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 24516 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / guest
we can retrive the max(sal),deptno,empno in aggreator stage.
way is
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=max(sal)
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Highlight the main features of datastage?
table actions available in oracle connector?
Describe the main features of datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the types of containers and how to create them?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How to manage date conversion in Datastage?
Give an idea of system variables.
What is a merge?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the main differences you have observed between 7.x and 8.x version of datastage?
Can you explain kafka connector?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How can one find bugs in job sequence?
What are the steps needed to create a simple basic datastage job?
