In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 18810 Views
- I also Faced
- E-Mail Answers
Answer Posted / rag
We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,
like select col1,col2,rownum
from tab1
where rownum=3
| Is This Answer Correct ? | 1 Yes | 21 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
Which is the t/r that builts only single cache memory?
What the difference is between a database, a data warehouse and a data mart?
what is degenerated dimension?
What are the different options available for update strategy?
What is a predefined event?
Why sorter is an active transformation?
What are the uses of etl tools?
list out all the transformations which use cache?
How would you join a node to the already existing domain?
What is meant by lookup transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Define enterprise data warehousing?
