ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
Question
how can find maximum salary by using Remove duplicate stage?
 Question Submitted By :: Data-Stage
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
R.D Stage remove the duplicates every one knows but u can
find max salary......
Give the key of salary order by descending other
option u can put=first
 
Is This Answer Correct ?    4 Yes 2 No
Narayana.3ds
 
Answer
# 2
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
Phani Kumar
 
 
 
Answer
# 3
In case an explicit sort stage is used like inteh reply
above, the sort will be done on emp_id(key field) and the
salary. But remove duplicate will be done only on emp_id. I
guess that this might result in a warning like 'sort and
remove duplicates keys do not match'.
 
Is This Answer Correct ?    0 Yes 0 No
Akila
 
Answer
# 4
https://www.docstoc.com/pro/2134166 
Is This Answer Correct ?    1 Yes 2 No
Anitha
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance Satyam 2
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?   1
what r the stages mostly used in realtime scenarios IBM 4
How do u call shellscript/Batch file from DS? HP 4
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S   3
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version? Wipro 12
how to get the unique records on multiple columns by using sequential file stage only   3
specify data stage strength?   1
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls TCS 5
types of errors in datastage? Reliance 2
what is the function in Transformer stage can act as Rank function in Oracle Reliance 1
how to handle null values using transformer stage?   1
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com