Interested to Buy Any Domain ? << Click Here >> for more details...
how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 14741 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / phani kumar
By using Sort stage, sort the data in Descending order, then
use remove duplicates stage, set option as first occurrence
of records. Then we will get max sal record first.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
EXPLAIN SCD
What steps should be taken to improve Datastage jobs?
Describe the architecture of datastage?
What is a merge?
How a source file is populated?
How to find value from a column in a dataset?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Lookup constraints
describe the Steps to confiure a Qlogic switch
Which warehouse using in your datawarehouse
What are routines in datastage? Enlist various types of routines.
What are the processing stages?
What are the various kinds of the hash file?
Why we use surrogate key?
What is meta stage?
