Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 43540 Views
- Infosys, I also Faced
- E-Mail Answers
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
Which is the t/r that builts only single cache memory?
What are the different clients of powercenter?
Is it possible to use a client with different version than that of its Informatica server?
What is rank index in rank transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is data transformation manager process?
How we can use union transformation?
Explain the aggregator transformation?
How to generate sequence numbers?
What is meant by query override?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many dimensions are there in informatica?
What is informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
