how do u get the first record from 50,000 records ?
Answers were Sorted based on User's Feedback
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
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 |
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 |
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 / 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 |
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 |
what is system requirement(SR) & business requirement(BR)?
connected and unconnected lookups?
How to generate the HTML output using Informatica.
how can import the data from the flat files?
What do you mean by filter transformation?
Write the different tools in the workflow manager?
What is InformaticaPowerCenter?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
What is deployment group?
what is parallel querying and what r hints.
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,