How to list Top 10 salary, without using Rank Transmission?
Answer Posted / sarvesh
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 | 24 No |
Post New Answer View All Answers
Explain dynamic target flat file name generation in informatica
What is the use of an aggregator cache file?
Tell me about Propagate functions in informatica
list out all the transformations which use cache?
What is lookup change?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Can informatica load heterogeneous targets from heterogeneous sources?
Explain incremental aggregation in informatica
Can you generate sequence numbers without using the sequence generator transformation?
Explain the aggregator transformation?
In development project what is the process to follow for an etl developer from day1
Explain lookup transformation is active in informatica
differences between service based and product based?
What is a transaction control transformation?
What are the guidelines to be followed while using union transformation?