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

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / chandra1983

10 Answers
19546 Views
TCS, UBS, I also Faced
E-Mail Answers

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