how do u get the first record from 50,000 records ?

Answer Posted / rv

select @ from <tbl> where rownum>2; im right ?
other wise mail to me rayallarv@gamil.com

Is This Answer Correct ?    2 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are active and passive transformations?

639


What is flashback table ? Advance thanks

1474


Explain your project of banking domian.

1208


my source is junk data how will u remove that junk data by using unix please any one replay me

3234


What is the benefit of partitioning a session?

617






In how many ways we can create ports?

694


Can we override a native sql query within informatica?

621


Explain the use of aggregator cache file?

666


What are the different ways to implement parallel processing in informatica?

851


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1031


Describe the impact of several join conditions and join order in a joiner transformation?

632


Design a mapping to load a target table with the following values from the above source?

867


Differences between connected and unconnected lookup?

599


What are data-driven sessions?

708


generate date / time dimension in informatica

710