how do u get the first record from 50,000 records ?
Answers were Sorted based on User's Feedback
Answer / chemistrya2z
select * from <tbl> where rownum<2;
|Is This Answer Correct ?||17 Yes||0 No|
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|
Answer / srinivasarao dasari
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|
Answer / somnath pain
I suppose u r working with informatica.
So here u can import the source and after the source use a
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.
|Is This Answer Correct ?||3 Yes||2 No|
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|
Answer / narsi
If it is flat file use sed command
|Is This Answer Correct ?||0 Yes||0 No|
Select * from(select rownum as rno,emp.* from emp) where rno=&n
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
---------- ---------- ---------- --------- ---------- --------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
|Is This Answer Correct ?||0 Yes||2 No|
Answer / subramanyam
use rank transformation u can get it
|Is This Answer Correct ?||1 Yes||4 No|
Answer / hanumantharao
select *from emp where rownum=1;
|Is This Answer Correct ?||1 Yes||10 No|
Answer / rv
select @ from <tbl> where rownum>2; im right ?
other wise mail to me email@example.com
|Is This Answer Correct ?||2 Yes||24 No|
can anyone explain me about sales project in informatica?
How you load distinct records into one target and duplicate records into another target?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to improve the session performance in informatica?
explain about informatica server architecture?
Why do you use Mapping Parameter and mapping variable?
how to calculate the optimum cache size in aggregator transformation?
what is constraint based load order
can you use flat file for lookup table?why?
how to load rows into fact table in data warehouse
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?
Explain the types of transformations?