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

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

More Informatica Interview Questions

What is substr in informatica?

0 Answers  


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,


write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,






What is meant by target load plan?

0 Answers  


How to join three sources using joiner?

0 Answers  


What is synonym?

2 Answers   Patni,


What is the status code?

1 Answers  


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  


Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,


Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,


Categories