Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,


What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,


How to improve the session performance in informatica?

3 Answers   Accenture,


explain about informatica server architecture?

1 Answers   IBM,






Why do you use Mapping Parameter and mapping variable?

0 Answers  


how to calculate the optimum cache size in aggregator transformation?

1 Answers  


what is constraint based load order

2 Answers   Cap Gemini,


can you use flat file for lookup table?why?

2 Answers   HCL,


how to load rows into fact table in data warehouse

0 Answers   Informatica,


One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


Explain the types of transformations?

0 Answers  






Categories