In a table, 4 person having same salary. How to get Third
person record only?
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 is session task and command task?
What are the designer tools for creating transformations?
What all are steps in up gradation of Informatica server?
What is the need of etl tools?
What is decode in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How do you promote a non-reusable transformation to reusable transformation?
In development project what is the process to follow for an etl developer from day1
What is dimensional table?
can u give example for factless fact table
Explain how to import oracle sequence into informatica?
Which are the different editions of informatica powercenter that are available?
Explain the pipeline partition with real time example?
what is degenerated dimension?