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


Please Help Members By Posting Answers For Below Questions

Explain the types of transformations?

687


Enlist few areas or real-time situations where informatica is required.

686


How to use procedural logic inside infromatica?

729


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1732


Explain why we use partitioning the session in informatica?

682






What is domain and gateway node?

797


Where is metadata stored?

697


How do you promote a non-reusable transformation to reusable transformation?

766


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

1976


Why update strategy and union transformations are active?

685


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1598


How to load a Dimension ? and how to load a fact table?

1044


What is informatica? Why do we need it?

740


What is lookup transformation?

701


What are the reusable transformations?

777