how to get the first row without using rank t/r?
Answers were Sorted based on User's Feedback
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 |
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 |
by using first function in aggregator transformation.
Is This Answer Correct ? | 5 Yes | 1 No |
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 |
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 |
What is substr in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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
What is the sql query overwrite in source qualifier in 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
What is meant by target load plan?
How to join three sources using joiner?
What is synonym?
What is the status code?
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?
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
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani