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 is the benefit of partitioning a session?

632


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1587


Explain the mapping variable usage example in informatica

635


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

610


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1189






What is a pre-defined event and user-defined event?

579


Explain in detail scd type 2 through mapping.

619


Explain about cumulative Sum or moving sum?

622


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1903


What are the differences between source qualifier and joiner transformation?

602


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1632


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

600


Explain what are the different types of transformation available in informatica.

575


What are the restrictions of union transformation?

581


What is dimensional table? Explain the different dimensions.

664