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

Answers were Sorted based on User's Feedback



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

Answer / chemistrya2z

select * from <tbl> where rownum<2;

Is This Answer Correct ?    17 Yes 0 No

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

Answer / anil

use first function in agg or seq->filter(rounum=1) then
connect to target .i am right or wrong?

Is This Answer Correct ?    6 Yes 1 No

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

Answer / srinivasarao dasari

Hi Chandra,

You did not mention the criteria that how do u want that
first record should be fetched.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / somnath pain

I suppose u r working with informatica.
So here u can import the source and after the source use a
expression transformation.
use a sq generator set start val to 1.
connect the nextval port to expession transformation.
apply a filter and set filter condition as nextval=1 connect
the filter o/p to target.
u will get the desired row.

regards,
Somnath

Is This Answer Correct ?    3 Yes 2 No

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

Answer / bsgsr

simple. connect the source to ranker select top and set no
of ranks to 1.

Is This Answer Correct ?    3 Yes 3 No

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

Answer / narsi

If it is flat file use sed command

Is This Answer Correct ?    0 Yes 0 No

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

Answer / amedela chandra sekhar

Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:

SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1

RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20

Is This Answer Correct ?    0 Yes 2 No

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

Answer / subramanyam

use rank transformation u can get it

Is This Answer Correct ?    1 Yes 4 No

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

Answer / hanumantharao

select *from emp where rownum=1;

Is This Answer Correct ?    1 Yes 10 No

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

Answer / 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

More Informatica Interview Questions

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


What is a filter transformation?

0 Answers  


What are the static cache and dynamic cache in informatica?

0 Answers  


What are the data movement modes in informatica?

0 Answers   Informatica,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,






A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


how to insert header after each group.

1 Answers   IBM,


Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  


i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,


What are the different options available for update strategy?

0 Answers  


Explain the informatica workflow?

0 Answers  


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,


Categories