how to get the first row without using rank t/r?

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

Question Posted / sree

7 Answers
11576 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get the first row without using rank t/r?..

Answer / moorthy g

In Source Qualifier Sql Override
Ex: Table Name: Dept1
SELECT DEPT1.DEPTNO, DEPT1.DNAME, DEPT1.LOC
FROM
DEPT1
WHERE ROWNUM=1

Is This Answer Correct ?

12 Yes

0 No

how to get the first row without using rank t/r?..

Answer / abhishek kumar

step 1
if first row h as not null then we can use first()
function in aggregator T/F.

step 2
use sequence generator T/F And filter T/F write condition
nextval=1

Is This Answer Correct ?

10 Yes

0 No

how to get the first row without using rank t/r?..

Answer / gandra krishna reddy

by using first function in aggregator transformation.

Is This Answer Correct ?

5 Yes

1 No

how to get the first row without using rank t/r?..

Answer / moorthy g

SQ-Sorter-Seq-Exp-Fiter(nextval=1)-Target

Is This Answer Correct ?

5 Yes

1 No

how to get the first row without using rank t/r?..

Answer / basi

your question is worng . because you are asking fist row
why are you using rank t/r

Is This Answer Correct ?

5 Yes

1 No

how to get the first row without using rank t/r?..

Answer / balakrishna

select empno,name,deptno,loc from emp where rownum=1
   and
first using sorter select asc,create expression t/r using the variable v_count=v_count+1,o_count=v_count after using the filter t/r to write condition o_count=1 connect filter t/r to target
   and
source--->sq--->seq--->exp--->filter--->target
   and
select * from emp where rownum=1minusselect * from emp where rownum=2

Is This Answer Correct ?

0 Yes

0 No

how to get the first row without using rank t/r?..

Answer / venkatgiri

select * from Table_name limit 1

Is This Answer Correct ?

1 Yes

3 No

Post New Answer