Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive the max(sal),deptno,empno in datastage?
- 13 Answers
- 24143 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / santhosh
Take aggrigrator o/p as reference link to look up then you
will gwt require o/p
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meta stage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
how many rows sorted in sort stage by default in server jobs
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How to reverse the string using SQL?
How do you import and export the datastage jobs?
Highlight the main features of datastage?
Why do we use link partitioner and link collector in datastage?
What is a quality stage in datastage tool?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the repository tables in datastage?
What is the difference between an operational datastage and a data warehouse?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
why do u need the IOS upgradation in a FC switch
