How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / nandhini
Create one dummy key and set the value as 1 for all input
columns and use remove duplicate stage. Here use this dummy
as key and use sorting, partitioning for dummy and company
columns & use sorting (descending) for salary column and in
properties tab, select duplicate to retain as last.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
in oracle target stage when we use load option and when we use upsert option?
What is the method of removing duplicates, without the remove duplicate stage?
What are the types of hashed files in data stage
What is datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are transforms and what is the differenece between routines and transforms?
how can we create rank using datastage?what is the meaning of rank?
What is orabulk stage?
What is the difference between in process and inter process?
Can you define merge?
What is size of a transaction and an array means in a datastage?
What are some different alternative commands associated with "dsjob"?
How to find value from a column in a dataset?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What can we do with datastage director?