Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44566 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / abhilash
do following steps
1.in source qualifier override the query with
"order by salary desc"
2. use seq gen tr on it and give column name as "sid"
3. next use filter tr. in that write condition like "sid<=10"
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Implementation methodology
What is sq transformation?
What is informatica etl tool?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is aggregate cache in aggregator transformation?
What is a rank transform?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is size of u r database?
Explain pushdown optimization and types in informatica
what is degenerated dimension?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
scenario where i can use only concurrent execution of workflow.
What are connected or unconnected transformations?
What is meant by target load plan?
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?
