:: 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                      
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)
how can find maximum salary by using Remove duplicate stage?
 Question Submitted By :: Data-Stage
I also faced this Question!!     Answer Posted By  
# 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
# 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
# 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
# 4 
Is This Answer Correct ?    1 Yes 2 No

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  All Rights Reserved.   ::