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 (184)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 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 (557)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 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
 
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that? Wipro 3
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know   1
what is the main differences between Lookup, Join and Merge stages?   9
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers... iGate 2
what is the definitions for Datawarehose and Datamart?   4
on how many columns we can perform aggregation in the aggregator stage? Reliance 1
How can we run same job in 1 day 2 times IBM 4
what is the function in Transformer stage can act as Rank function in Oracle Reliance 1
what is factless fact table? IBM 3
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash, tcs 3
What is Cleanup Resources and when do you use it?   2
what is time dimension? and how to populate time demension TCS 2
 
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