ALLInterview.com :: Home Page KalAajKal.com
 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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
How to list Top 10 salary, without using Rank Transmission?
 Question Submitted By :: Kumar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to list Top 10 salary, without using Rank Transmission?
Answer
# 1
use sorter transformation with ascending,sequence and filter....
 
Is This Answer Correct ?    1 Yes 0 No
Cool
 
  Re: How to list Top 10 salary, without using Rank Transmission?
Answer
# 2
if it is flat file ur answer is write,if it is relational 
souce then go to source qualifier properties there u write 
the query like
   select distinct a.* from t1 a where 10=(select sal from 
t1 b where a.sal>b.sal)
  i think it is working
 
Is This Answer Correct ?    1 Yes 4 No
Sarvesh
 
 
 
  Re: How to list Top 10 salary, without using Rank Transmission?
Answer
# 3
only use the Aggregator function.....
   
    first(sal>=values)
 
Is This Answer Correct ?    0 Yes 2 No
Murugan
 
  Re: How to list Top 10 salary, without using Rank Transmission?
Answer
# 4
SQL:
SELECT id, salary from <table name> where rownum <= 10
       ORDER BY salary DESC;
 
Is This Answer Correct ?    3 Yes 2 No
Raka
 
  Re: How to list Top 10 salary, without using Rank Transmission?
Answer
# 5
it can achieve with inline view query in sqt/r
 
Is This Answer Correct ?    0 Yes 0 No
Jaipal
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?  4
Explain the flow of data in Iinformatica?  1
what is meant by lookup caches?  1
what is the gap analysis?  1
how do u tune queries?  1
Can you copy the session to a different folder or repository?  1
what are the difference between Informatica 7.1 and 8.1?  4
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?  1
What is the target load order?  2
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach Virtusa4
What is A cache?  1
How the informatica server sorts the string values in Rank transformation?  1
what are surrogate keys?  3
How to view and Generate Metadata Reports?  1
What are the different threads in DTM process?  1
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ? Target6
what is polling?  1
we r using aggregator with out using groupby? HSBC2
What are the joiner caches?  2
Explain about HLD and LLD ? Accenture7
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com