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 |
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?
What is a filter transformation?
What are the static cache and dynamic cache in informatica?
What are the data movement modes in informatica?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
how to insert header after each group.
Can you generate sequence numbers without using the sequence generator transformation?
i have 2 session s1 execute s2 load first session fail what is the reason?
What are the different options available for update strategy?
Explain the informatica workflow?
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.