how to retrive the max(sal),deptno,empno in datastage?
Answer Posted / srikanth
hi vamsi
this is srikanth
if it is seq file
it is not at all possible
because we need to get the empno,deptno also.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is apt_config in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the functionalities of link partitioner?
in oracle target stage when we use load option and when we use upsert option?
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.
Differentiate between operational datastage (ods) and data warehouse?
How do u convert the columns to rows in datastage?
What is the importance of the exception activity in datastage?
What is a folder? Difference types of stages?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the different plug-ins stages used in your projects?
What is active and passive stage?
How do you reject records in a transformer?
What is the difference between validated and compiled in the datastage?
Describe the main features of datastage?