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
- 22078 Views
- I also Faced
- E-Mail Answers
Answer Posted / mr.lee
id sal
101 1000
102 1000
103 1000
104 1000
Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is complex mapping?
Mention a few design and development best practices for informatica?
What are connected or unconnected transformations?
What are the popular informatica products?
Can we get 1st record through Informatica(without sequence number).
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the differences between oltp and olap?
How you can differentiate between connected lookup and unconnected lookup?
Describe the impact of several join conditions and join order in a joiner transformation?
Design a mapping to load a target table with the following values from the above source?
What is a passive transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Differences between version 7.x and 8.x.
