In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / ravikumar2614
srikanth answer will work only if the table having only 4 records which r same.
if the table having 10 records, and 4 records r same out of 10 (1st, 5th, 6th, 8th records r same)
in above situation srikanth solution will not work
if wrong please correct me on ravi.info2614@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the types of transformations?
Enlist few areas or real-time situations where informatica is required.
How to use procedural logic inside infromatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain why we use partitioning the session in informatica?
What is domain and gateway node?
Where is metadata stored?
How do you promote a non-reusable transformation to reusable transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Why update strategy and union transformations are active?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to load a Dimension ? and how to load a fact table?
What is informatica? Why do we need it?
What is lookup transformation?
What are the reusable transformations?