Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21658 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 differs when we choose the sorted input for aggregator transformation?
What will be the approach?
What is a rank transform?
whats the logic to load the lower level of granularity of data to fact table.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the difference between Active and Passive transformation?
What is the meaning of decode in informatica?
What are the types of schemas we have in data warehouse.
What are the differences between source qualifier and joiner transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Which development components of informatica have the highest usage?
What are the different versions of informatica?
Differentiate between a repository server and a powerhouse?
What is an expression transformation in informatica?
How do you use reject loader.
