how to retrive the max(sal),deptno,empno in datastage?
Answer Posted / nagaraju k
first take oracle->aggregator->lookup->dataset
next take 2oracle stages and then take join stage join to connect lookup stage then success fully answre will come
Any doubt means call me
+960022516
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the types of containers?
How can we improve the performance in datastage?
What are the types of hashed files in data stage
What are the functionalities of link partitioner and link collector?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Can we use target hash file as a lookup ?
What are the functionalities of link collector?
describe the Steps to confiure a Qlogic switch
Can you explain tagbatch restructure operator?
What are the different kinds of views available in a datastage director?
What are the steps required to kill the job in Datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is ibm datastage?
How to reverse the string using SQL?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara